@@PowerBIPark Dude! It worked perfectly!And at one point, I wanted to enter the min y value in the chart for the various kpi's I was measuring but had no clue how to write a dax script for dynamically identifying the min value based on "Selected Measure". And then here you come at 34:18 with a dax formula for the max y. I could have kissed you! Much love and respect from Canada! 💯
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.
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 :)
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 😞
@@PowerBIPark That's awful to hear, some people just... suck. Your video walkthroughs would be enough for me. Maybe even just sharing the formulas for a few of the measures could be useful for most users too. Either way, keep up the great work!
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.
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!
i am facing the same problem where i am getting the value 4_SM Date Param + 4_SM Date Param Past Period, its not correct, just subtract the 4_SM Date Param. I think this will provide the last period value.
maybe a dumb question but I want to show all 3 of them next to each other as you do in the preview. However, when i copy the grouped visual I am not able to use the slicer on the copied visual. I want each slicer to work independent for the specific kpi card. Can anyone please help me
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.
HI Park, thank you so much for sharing this vid, and it does help me in many ways!! However I noticed there is some issue with my dashboard (where I try to duplicate what you did there), after setting everything up, the max date seems to have a lil issue (not showing the lastest date, but shows kinda weird max date for each date selection.. Example (Date selection > maxdate shown) : 7D > 21/1/25 (this is correct) 14D > 13/1/25 (wrong-somehow its -7days from "7D" 1M > 6/1/25 (wrong again) 2M > 21/12/24 (wrong again) I have tried everything by max-ing the maxDate regardless of date tables (which works in paper), but when I turn it into line visual, then pulling the calendar date into X-axis, it goes back to the above maxdate. Could you advice where did I done wrong? Thanks a lot for thissss!
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?
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?
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).
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
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
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...
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.
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....
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?
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.
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.
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?
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,
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?
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 🎉
probably the best power bi youtuber
I'm 6 minutes in and so excited! This is awesome! Subbed!
Welcome aboard!
@@PowerBIPark Dude! It worked perfectly!And at one point, I wanted to enter the min y value in the chart for the various kpi's I was measuring but had no clue how to write a dax script for dynamically identifying the min value based on "Selected Measure". And then here you come at 34:18 with a dax formula for the max y. I could have kissed you! Much love and respect from Canada! 💯
Eagerly waiting for this KPI workshop. Thanks for Sharing!! This is really awesome.
Glad you like it!
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 :)
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 :)
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 😞
Could you help me with the pbix file.
@@PowerBIPark That's awful to hear, some people just... suck. Your video walkthroughs would be enough for me. Maybe even just sharing the formulas for a few of the measures could be useful for most users too. Either way, keep up the great work!
Congratulations on more fabulous content. You have a remarkable talent for making complex topics easily understandable! thanks so much!
Wow, thank you!
Do I have a glitch in my PBI desktop version that the Vertical Alignment mentioned at 30:22 is no longer available, or was that an "update"? 🤦♂
man, this is GOLD. Solved my issue here !!! Thank you very much
Nice! Glad it helped someone immediately x)
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.
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
This helped me a lot, thanks!
This is gold! Thank you!
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!
i am facing the same problem where i am getting the value 4_SM Date Param + 4_SM Date Param Past Period, its not correct, just subtract the 4_SM Date Param. I think this will provide the last period value.
This was wonderful. Very easy to follow. Thank you!
This video is like a new level from you! Thanks a lot for your valuable content.
Thanks man, I appreciate it :]
maybe a dumb question but I want to show all 3 of them next to each other as you do in the preview. However, when i copy the grouped visual I am not able to use the slicer on the copied visual. I want each slicer to work independent for the specific kpi card. Can anyone please help me
how do i add 1d filter ?
Fantastic, clean neat and informative
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
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.
HI Park, thank you so much for sharing this vid, and it does help me in many ways!! However I noticed there is some issue with my dashboard (where I try to duplicate what you did there), after setting everything up, the max date seems to have a lil issue (not showing the lastest date, but shows kinda weird max date for each date selection..
Example (Date selection > maxdate shown) :
7D > 21/1/25 (this is correct)
14D > 13/1/25 (wrong-somehow its -7days from "7D"
1M > 6/1/25 (wrong again)
2M > 21/12/24 (wrong again)
I have tried everything by max-ing the maxDate regardless of date tables (which works in paper), but when I turn it into line visual, then pulling the calendar date into X-axis, it goes back to the above maxdate. Could you advice where did I done wrong? Thanks a lot for thissss!
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?
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 :)
I have problem opening the file. It says it’s either encrypted or corrupted.
Great stuff and so many useful tips!!!
Glad you think so!
Great tutorial. But if TY in my dataset is 2020, if TY is not 2024/current year, how can I manage TY? My dataset shows blank after clicking TY.
This is sick 🔥 Thanks Injae
Cheers :)
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: th-cam.com/video/egY0M6kGK8g/w-d-xo.html
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
Simply Amazing!! Thanks form sharing!
Beautiful. i do not understand the SM PAST PERIOD REFERENCE LABEL AS I CANT SEE IT TOTALLY. CAN ANYBODY HELP?
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 :)
How do you label moving average on the line?
Hey, it's an option called Series labels :)
Great video Injae.
Thank you!
Thank you, this is great!
Amazing! Thank you very much!!
Awesome content! Thanks for sharing!
Thanks for watching
Handy insights!. Thanks for sharing
Glad it was helpful!
Thanks for sharing! You are a Star!
Appreciate you!
Great breakdown - thanks!
Very welcome!
Thanks a lot.... Awesome
Thanks for sharing! Very insightful!
Thanks! Glad to see you making videos too :)
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.🥳
That was good learning. Thank You
Glad it was helpful!
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!
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...
Could you show how to get the Moving Average label? Thank you!! PS. This is amazing and great freaking work!!
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 :)
Excellent, I subscribe
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 :)
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
Looks great.
Where can we get the data to practice this excercise.
Take it from my github, it's linked in the description
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 :)
Excelent...like always
Appreciate it
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
Amazing visual
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?
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.
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, th-cam.com/video/CcUV-9_z5uY/w-d-xo.htmlsi=Racfkz36vfUvNFck which should take care of the first part :)
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?
Excellent... thank for sharing
Welcome 😊
this is so good.
Glad you think so :)
Thanks for explaining :-D
You bet!
Such an amazing one..
Thanks!
Thank you!
You're welcome!
that's sick.....thank you
Glad you like it!
Hello Sir,
Great Work.
But could you upload videos related Advanced DAX.
Maybe in the future :)
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?
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,
Great!!!!! Topppp
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 :)
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 :)
excelente
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!
997 Cartwright Inlet