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!
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.
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 - 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
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).
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
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...
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.
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....
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?
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?
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.
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,
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!
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?
This kpi in just one visual is insane, just saving at least two or three pages into one chart. It is great 🎉
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 :)
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!
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!
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 gold! Thank you!
man, this is GOLD. Solved my issue here !!! Thank you very much
Nice! Glad it helped someone immediately x)
This helped me a lot, thanks!
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 :]
Fantastic, clean neat and informative
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.
Great stuff and so many useful tips!!!
Glad you think so!
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
This is sick 🔥 Thanks Injae
Cheers :)
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.
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!
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?
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?
Awesome content! Thanks for sharing!
Thanks for watching
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 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?
Amazing! Thank you very much!!
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
Great breakdown - thanks!
Very welcome!
Handy insights!. Thanks for sharing
Glad it was helpful!
Thank you, this is great!
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 video Injae.
Thank you!
Could you show how to get the Moving Average label? Thank you!! PS. This is amazing and great freaking work!!
That was good learning. Thank You
Glad it was helpful!
Thanks for sharing! Very insightful!
Thanks! Glad to see you making videos too :)
Thanks for sharing! You are a Star!
Appreciate you!
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...
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 great!! Thank you so much for this..
No worries!
how do i add 1d filter ?
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.
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 :)
Excellent, I subscribe
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 :)
Excelent...like always
Appreciate it
How do you label moving average on the line?
Hey, it's an option called Series labels :)
Excellent... thank for sharing
Welcome 😊
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 :)
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?
I have problem opening the file. It says it’s either encrypted or corrupted.
Hello Sir,
Great Work.
But could you upload videos related Advanced DAX.
Maybe in the future :)
Looks great.
Thanks a lot.... Awesome
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
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 :)
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 get that "sugest a visual" window?
enable 'on object interaction' settings > preview
That's correct, thanks for sharing :)
Thanks for explaining :-D
You bet!
Where can we get the data to practice this excercise.
Take it from my github, it's linked in the description
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,
Such an amazing one..
Thanks!
Amazing visual
this is so good.
Glad you think so :)
that's sick.....thank you
Glad you like 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
Thank you!
You're welcome!
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 :)
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?
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!
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 :)
Great!!!!! Topppp
excelente
997 Cartwright Inlet