The biggest win I am seeing here as a beginner is how modular this is. Literally 1 day into visuals I am already pissed off I lose all my format including ref labels and details if I change the first-level data field or measure. It feels like a beginner trap that you have to rebuild rebuild rebuild and you certainly can't reuse. So I figure out I should probably just make a measure for every dynamic bit of every visual including just slapping text placeholders in there so I can connect the displayed measure to an actual measure once I've got it dialed in. But combined with this "SM_" situation is even better for reusing the same group of visuals for multiple situations because I can just add more selectables to my table and not even update the visuals at all. Heck, I could pre-slice them then hide the slicer(s) if I don't intend the user to interact with a particular page. Consier my mind blown.
This is great. I wish this video came out last year because I fumbled through creating something similar except I was using a combination of field parameters and 2 calculation groups. This is a much cleaner and simpler approach. Thanks for sharing.
Amazing post, very informative and well explained! One question regarding the calculation of the past period, in my case the last week. I had to add +1 for Start of the Period and -1 for end of the period. Else my week had 9 days and there would be overlap on the last day of the previous week with the first day of the actual week. 4_SM Date Param Past Period = CALCULATE( [3_Selected Measure], // The measure to calculate KEEPFILTERS( DATESBETWEEN( Dim_Date[Date], // The date column from your Date table [3_Selected Min Date Past Period]+1, // The start date for the period [3_Selected Min Date] -1 // The end date for the period ) ) ) Maybe you can comment on that :) Again, well done!
Awesome content. Including the PBIX file is legendary. I was fully expecting a paywall or sign-up to get the materials. Absolutely amazing stuff, will be following to learn more!
Thanks man! Unfortunately I found out a youtuber was stealing my pbix files and selling them.... so I might not be doing the pbix for free that much longer 😞
Great tutorial, Injae. Your approach to creating KPI cards using the new cards and dynamic measures is very effective. I appreciate that you only provide the starting file instead of the final one. It really encourages us to practice and learn the techniques. Hands-on experience is the best way to learn, and your method supports that perfectly. You should definitely consider creating a full course on Udemy or a similar platform; it would be a hit for sure. Keep up the great work
Appreciate your kind words! I'm building some courses right now - basically I want to make videos like this but more end-to-end, teaching people to make mockups with design in mind, and then leading them to make stuff like this :)
Great way to display KPI's for some reason everything works great for me besides the TY in the Past Period Reference Label shows value of the entire year (last year) should be the period up to the same date this year last year, the other periods works fine.
Hey Injae amazing stuff and super helpful, however I want to show the same for past 5 years although when I am using slicer it is showing only current year data, also I am not using date table. If you could help, would be great
A short question, that's probably a lot more complicated. How do you need to tweak the metrics to be able to show and change the data on the visual that has something except dates in the X-axis ( for example if you had a Male/Female column in your 'Data' table?
This is very nice and with your pbix also very "easy" to follow! Thanks for that! I really enjoy these video's. I only can't reproduct the (for example) Previous week value for the total impressions. When I use the data I would come to 88,69k... in stead of 105,40. What am I doing wrong?
I want quality content from you in Bulk Quantity, please keep making such videos and full tutorials on DAX(Advanced KPIs) will be appreciated with some modelling workshops( as this content is less on youtube so far).
Hi, First of all, thank you very much for your inspiring videos. My question now is how you managed with the 3 cards next to each other without them influencing each other. I couldn't manage it with the decoupling. Thank you very much
@@PowerBIParkThanks for the info! I tried that but it didn't work. My fault was, I hadn't noticed, that PowerBI created autom. relations for the objects which messed everything up...
Excelente tutorial, pero creo que tiene un error. No efectúa bien el cálculo de la semana anterior. En vez de coger 7 días, coge 9 días. La suma de la semana anterior para las Impresiones no son 105400. El resultado correcto son 88689. Muchas gracias. Un cordial saludo,
this is really great, thanks for sharing! Is it possible to create a Month To Date [MTD] and Previous Month To Date [PMTD] so that if you are coming the same number of days in current month versus previous month? Also, if you had a slicer for Year/Month, is there any way for the dynamic formulas to take these into consideration as well? Thanks again!
Yes you can! I've done this before, and basically it works best if you add a filter to your current and past dates, that looks at the day of the month.
A great question! You can definitely use Eomonth, but that would give you the last day of the month instead of exactly 1 month. So you might want to use it to look at full months, but it's a different date right?
Hi - one quick thought - I would add white space around the details highlight with the conditional background you can add them with Unicode 127 - I just released a short where I did it pretty quickly
This is incredible, thank you for sharing! I watched it from beginning to end and was able to replicate it. It would be fantastic if you could explain how to include SVG social media platform icons as selectors and include more than one platform per KPI card. Additionally, it would be great to display the cost if there's an investment involved.
Thanks for posting. Im sorry I didnt watch the entire video yet but I skipped through it. Maybe the following question is answered but I didnt see it yet. Am i correct that this method always shows the data at the day level? If so, I think it would be very powerful if the shown date granularity would be dynamic. For example: 1W -> show in days 1Y -> show in months Thats not possible with this method right? Or do you know a way?
I really like this, thanks for the great video... I think I will do some workshops on the video, I think there are quite a few ideas in there that are worth developing/practicing for my students....
Really Great Video. I"m struggling with the section where you add the 5_SM Moving Average Date Param. When I add this line to my chart It does not filter for only the date selected by the Date selection filter. The 4_SM Date Param shows the correct date range but not the moving average. Do you have any idea why this is happening? Note I'm using my own data for this.
Hey Injae! Glad to see youre still pumping out some quality content! Hope you haven't forgotten your first fan before you got so big 😔 Wanna catch up sometime?
4_SM Date Param Past Period = CALCULATE( [3_Selected Measure], KEEPFILTERS( DATESBETWEEN( 'Calendar'[Date], [3_Selected Min Date Past Period], [3_Selected Min Date] -1 ) // I think here should be again -1, otherwise we are overlapping the periods, I am right? ) ) I am totally in love with these tutorials !! Thank you for that!
This kpi in just one visual is insane, just saving at least two or three pages into one chart. It is great 🎉
The biggest win I am seeing here as a beginner is how modular this is.
Literally 1 day into visuals I am already pissed off I lose all my format including ref labels and details if I change the first-level data field or measure. It feels like a beginner trap that you have to rebuild rebuild rebuild and you certainly can't reuse.
So I figure out I should probably just make a measure for every dynamic bit of every visual including just slapping text placeholders in there so I can connect the displayed measure to an actual measure once I've got it dialed in. But combined with this "SM_" situation is even better for reusing the same group of visuals for multiple situations because I can just add more selectables to my table and not even update the visuals at all. Heck, I could pre-slice them then hide the slicer(s) if I don't intend the user to interact with a particular page.
Consier my mind blown.
This is great. I wish this video came out last year because I fumbled through creating something similar except I was using a combination of field parameters and 2 calculation groups. This is a much cleaner and simpler approach. Thanks for sharing.
I've gotten some flak that it's nothing new, but glad you still see some value in it :)
Amazing post, very informative and well explained!
One question regarding the calculation of the past period, in my case the last week.
I had to add +1 for Start of the Period and -1 for end of the period.
Else my week had 9 days and there would be overlap on the last day of the previous week with the first day of the actual week.
4_SM Date Param Past Period =
CALCULATE(
[3_Selected Measure], // The measure to calculate
KEEPFILTERS(
DATESBETWEEN(
Dim_Date[Date], // The date column from your Date table
[3_Selected Min Date Past Period]+1, // The start date for the period
[3_Selected Min Date] -1 // The end date for the period
)
)
)
Maybe you can comment on that :)
Again, well done!
Awesome content. Including the PBIX file is legendary. I was fully expecting a paywall or sign-up to get the materials. Absolutely amazing stuff, will be following to learn more!
Thanks man! Unfortunately I found out a youtuber was stealing my pbix files and selling them.... so I might not be doing the pbix for free that much longer 😞
Eagerly waiting for this KPI workshop. Thanks for Sharing!! This is really awesome.
Glad you like it!
Learned a lot here, it is not just the overall awesome card visual, but each of those measures is a problem solver.
Thank you
Awesome, I appreciate that. Check out the part 2 of this video :)
Great tutorial, Injae. Your approach to creating KPI cards using the new cards and dynamic measures is very effective. I appreciate that you only provide the starting file instead of the final one. It really encourages us to practice and learn the techniques. Hands-on experience is the best way to learn, and your method supports that perfectly. You should definitely consider creating a full course on Udemy or a similar platform; it would be a hit for sure. Keep up the great work
Appreciate your kind words! I'm building some courses right now - basically I want to make videos like this but more end-to-end, teaching people to make mockups with design in mind, and then leading them to make stuff like this :)
Great way to display KPI's for some reason everything works great for me besides the TY in the Past Period Reference Label shows value of the entire year (last year) should be the period up to the same date this year last year, the other periods works fine.
man, this is GOLD. Solved my issue here !!! Thank you very much
Nice! Glad it helped someone immediately x)
Congratulations on more fabulous content. You have a remarkable talent for making complex topics easily understandable! thanks so much!
Wow, thank you!
Hey Injae amazing stuff and super helpful, however
I want to show the same for past 5 years although when I am using slicer it is showing only current year data, also I am not using date table.
If you could help, would be great
A short question, that's probably a lot more complicated.
How do you need to tweak the metrics to be able to show and change the data on the visual that has something except dates in the X-axis ( for example if you had a Male/Female column in your 'Data' table?
This is very nice and with your pbix also very "easy" to follow! Thanks for that! I really enjoy these video's. I only can't reproduct the (for example) Previous week value for the total impressions. When I use the data I would come to 88,69k... in stead of 105,40. What am I doing wrong?
I want quality content from you in Bulk Quantity, please keep making such videos and full tutorials on DAX(Advanced KPIs) will be appreciated with some modelling workshops( as this content is less on youtube so far).
Appreciate this :) You can check out the part 2 of this video: ua-cam.com/video/egY0M6kGK8g/v-deo.html
Hi,
First of all, thank you very much for your inspiring videos. My question
now is how you managed with the 3 cards next to each other without them
influencing each other.
I couldn't manage it with the decoupling.
Thank you very much
It's just using edit interactions :)
@@PowerBIParkThanks for the info! I tried that but it didn't work. My fault was, I hadn't noticed, that PowerBI created autom. relations for the objects which messed everything up...
This was wonderful. Very easy to follow. Thank you!
Excelente tutorial, pero creo que tiene un error. No efectúa bien el cálculo de la semana anterior. En vez de coger 7 días, coge 9 días. La suma de la semana anterior para las Impresiones no son 105400. El resultado correcto son 88689. Muchas gracias. Un cordial saludo,
Could you show how to get the Moving Average label? Thank you!! PS. This is amazing and great freaking work!!
Thank you for this great informative video. How can I add the 'Moving Average' text at the end of the line? Could a formatted line have been added?
All you need to do is turn on series labels in the formatting panel:)
@@PowerBIPark Alright, I found it, thank you very much.🥳
this is really great, thanks for sharing! Is it possible to create a Month To Date [MTD] and Previous Month To Date [PMTD] so that if you are coming the same number of days in current month versus previous month? Also, if you had a slicer for Year/Month, is there any way for the dynamic formulas to take these into consideration as well?
Thanks again!
Yes you can! I've done this before, and basically it works best if you add a filter to your current and past dates, that looks at the day of the month.
Hello Injae, is there any complications if you use EOMONTH instead of EDATE?, thanks in advance.
A great question! You can definitely use Eomonth, but that would give you the last day of the month instead of exactly 1 month. So you might want to use it to look at full months, but it's a different date right?
Hi - one quick thought - I would add white space around the details highlight with the conditional background you can add them with Unicode 127 - I just released a short where I did it pretty quickly
That's a great idea!
This video is like a new level from you! Thanks a lot for your valuable content.
Thanks man, I appreciate it :]
Thank you, this is great!
This is incredible, thank you for sharing! I watched it from beginning to end and was able to replicate it. It would be fantastic if you could explain how to include SVG social media platform icons as selectors and include more than one platform per KPI card. Additionally, it would be great to display the cost if there's an investment involved.
I have a video for using images in slicers, ua-cam.com/video/CcUV-9_z5uY/v-deo.htmlsi=Racfkz36vfUvNFck which should take care of the first part :)
Thanks for posting. Im sorry I didnt watch the entire video yet but I skipped through it. Maybe the following question is answered but I didnt see it yet.
Am i correct that this method always shows the data at the day level?
If so, I think it would be very powerful if the shown date granularity would be dynamic.
For example:
1W -> show in days
1Y -> show in months
Thats not possible with this method right? Or do you know a way?
It's pretty simple, you just need to use a field parameter :)
Thank you for this very nice way of teaching! I realy liked it and learned new things as well!
Awesome! Make sure to check out the latest video, it builds on these cards a bit more
Hello Sir,
Great Work.
But could you upload videos related Advanced DAX.
Maybe in the future :)
I really like this, thanks for the great video...
I think I will do some workshops on the video, I think there are quite a few ideas in there that are worth developing/practicing for my students....
Sounds great! This is just a peek into some of the stuff we can do :)
Looks great.
Really Great Video. I"m struggling with the section where you add the 5_SM Moving Average Date Param. When I add this line to my chart It does not filter for only the date selected by the Date selection filter. The 4_SM Date Param shows the correct date range but not the moving average. Do you have any idea why this is happening? Note I'm using my own data for this.
Are you using a date table?
@@PowerBIPark, yes. I even deleted my own date table and created a new one using the Bravo app, as you suggested, but it still had the same issue.
The problem will probably be the last date function. You could try changing that to just [current date] - selected date
did you ever get this to work? I'm having the same issue, and I don't quite understand his reply
@@mkbrown1982 no I didn't
Awesome content! Thanks for sharing!
Thanks for watching
how do i add 1d filter ?
Great video Injae.
Thank you!
Hey Injae! Glad to see youre still pumping out some quality content! Hope you haven't forgotten your first fan before you got so big 😔 Wanna catch up sometime?
Hey man, hope you're doing well! Let's catch a game sometime :)
Thanks a lot.... Awesome
This video was awesome! Definitely trying this out tomorrow. Do you take office hours? 😂😂
Glad you liked it :) I used to do random hours on topmate but I don't really right now :)
Great breakdown - thanks!
Very welcome!
Great stuff and so many useful tips!!!
Glad you think so!
That was good learning. Thank You
Glad it was helpful!
Simply Amazing!! Thanks form sharing!
Handy insights!. Thanks for sharing
Glad it was helpful!
This is sick 🔥 Thanks Injae
Cheers :)
Thanks for sharing! Very insightful!
Thanks! Glad to see you making videos too :)
Thanks for sharing! You are a Star!
Appreciate you!
How do you label moving average on the line?
Hey, it's an option called Series labels :)
Where can we get the data to practice this excercise.
Take it from my github, it's linked in the description
12:24 I can't get the conection established b/w the moving average and date salection , I did not made any change in dax
You should be using moving average date param :)
@@PowerBIPark now irealised that at 13:16 my link b/w date selection and bar chart is not working
I have problem opening the file. It says it’s either encrypted or corrupted.
have you also posted the file which is final made by KPI on power bi
I'm thinking about making it available for my patreon supporters, but... this literally tells you how to do it :)
4_SM Date Param Past Period =
CALCULATE(
[3_Selected Measure],
KEEPFILTERS(
DATESBETWEEN(
'Calendar'[Date],
[3_Selected Min Date Past Period],
[3_Selected Min Date] -1 ) // I think here should be again -1, otherwise we are overlapping the periods, I am right?
)
)
I am totally in love with these tutorials !! Thank you for that!
Excellent, I subscribe
Amazing visual
Excellent... thank for sharing
Welcome 😊
this is great!! Thank you so much for this..
No worries!
How do you get that "sugest a visual" window?
enable 'on object interaction' settings > preview
That's correct, thanks for sharing :)
Excelent...like always
Appreciate it
Out of curiousity. Why obscure the data itself? why so protective of this data?
A really good question, but why wouldn't you be protective of personal data?
Thank you!
You're welcome!
that's sick.....thank you
Glad you like it!
Great!!!!! Topppp
Such an amazing one..
Thanks!
this is so good.
Glad you think so :)
Thanks for explaining :-D
You bet!
Should be illegal to have all this value for free.
Thank you very much for sharing!
Cheers mate!
I might put some of this content into courses in the future - so enjoy it now :)
sir downloaded the power bi report but visual are not showing can you please send me the pbix with visual it will be help ful to us
You have the starter report and a video telling you how to do it, I think that's as good as it gets
excelente
997 Cartwright Inlet