The Best KPI Cards In Power BI

[@socoloco9621]

This kpi in just one visual is insane, just saving at least two or three pages into one chart. It is great 🎉

[@atulbihari7473]

Eagerly waiting for this KPI workshop. Thanks for Sharing!! This is really awesome.

[@PowerBIPark]

Glad you like it!

[@John14_]

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.

[@PowerBIPark]

I've gotten some flak that it's nothing new, but glad you still see some value in it :)

[@LukasReese-v1g]

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!

[@codroh1]

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!

[@PowerBIPark]

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 😞

[@rishikataria3271]

Could you help me with the pbix file.

[@codroh1]

@@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!

[@kais.rekouche]

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

[@PowerBIPark]

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 :)

[@ShabibAlHasani]

Learned a lot here, it is not just the overall awesome card visual, but each of those measures is a problem solver. Thank you

[@PowerBIPark]

Awesome, I appreciate that. Check out the part 2 of this video :)

[@freipfeifenprospekt]

Congratulations on more fabulous content. You have a remarkable talent for making complex topics easily understandable! thanks so much!

[@PowerBIPark]

Wow, thank you!

[@rkortez]

This is gold! Thank you!

[@HenriqueTOLEDO-s6y]

man, this is GOLD. Solved my issue here !!! Thank you very much

[@PowerBIPark]

Nice! Glad it helped someone immediately x)

[@brettwilson3795]

Fantastic, clean neat and informative

[@nickukragan7228]

This video is like a new level from you! Thanks a lot for your valuable content.

[@PowerBIPark]

Thanks man, I appreciate it :]

[@Nezarus0]

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.

[@praphulshresth]

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

[@PowerBIPark]

You should be using moving average date param :)

[@praphulshresth]

@@PowerBIPark now irealised that at 13:16 my link b/w date selection and bar chart is not working

[@northfisk]

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?

[@experience_kingsley]

This was wonderful. Very easy to follow. Thank you!

[@rm_pranto]

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.

[@Yeyeruu]

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

[@simonrozenberg8304]

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.

[@Andjingsan]

Thank you for this very nice way of teaching! I realy liked it and learned new things as well!

[@PowerBIPark]

Awesome! Make sure to check out the latest video, it builds on these cards a bit more

[@Reihill83]

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?

[@mmesomakelvin6105]

Beautiful. i do not understand the SM PAST PERIOD REFERENCE LABEL AS I CANT SEE IT TOTALLY. CAN ANYBODY HELP?

[@TheInfractor10]

Amazing! Thank you very much!!

[@mariabaranova4445]

Great stuff and so many useful tips!!!

[@PowerBIPark]

Glad you think so!

[@zionoluwasegun]

This is sick 🔥 Thanks Injae

[@PowerBIPark]

Cheers :)

[@martanoguerassancho]

Simply Amazing!! Thanks form sharing!

[@gulcecuruk6025]

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?

[@PowerBIPark]

All you need to do is turn on series labels in the formatting panel:)

[@gulcecuruk6025]

@@PowerBIPark Alright, I found it, thank you very much.🥳

[@antonycatella5901]

Great video Injae.

[@PowerBIPark]

Thank you!

[@DropMaterializedView]

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

[@PowerBIPark]

That's a great idea!

[@fsanfo]

Awesome content! Thanks for sharing!

[@PowerBIPark]

Thanks for watching

[@flotterotto4491]

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

[@PowerBIPark]

It's just using edit interactions :)

[@flotterotto4491]

@@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...

[@oreoresi31]

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?

[@PowerBIPark]

Hey man, hope you're doing well! Let's catch a game sometime :)

[@nancypakou]

Could you show how to get the Moving Average label? Thank you!! PS. This is amazing and great freaking work!!

[@SHAUNVINDA]

how do i add 1d filter ?

[@HarryBowen]

Thank you, this is great!

[@muhammadzakiahmad8069]

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).

[@PowerBIPark]

Appreciate this :) You can check out the part 2 of this video: kzbin.info/www/bejne/m5i8YYBsoKx-bsk

[@stuartdouglas8623]

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!

[@PowerBIPark]

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.

[@mcwahaab]

Handy insights!. Thanks for sharing

[@PowerBIPark]

Glad it was helpful!

[@businessinsights_AlexRobe]

Great breakdown - thanks!

[@PowerBIPark]

Very welcome!

[@juanignacioXI]

Hello Injae, is there any complications if you use EOMONTH instead of EDATE?, thanks in advance.

[@PowerBIPark]

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?

[@abdelytics]

Thanks for sharing! You are a Star!

[@PowerBIPark]

Appreciate you!

[@laurieer9633]

I have problem opening the file. It says it’s either encrypted or corrupted.

[@anjaliunnikrishnan5814]

That was good learning. Thank You

[@PowerBIPark]

Glad it was helpful!

[@PorcuBI]

Thanks for sharing! Very insightful!

[@PowerBIPark]

Thanks! Glad to see you making videos too :)

[@imstillbreathing1]

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.

[@PowerBIPark]

Are you using a date table?

[@imstillbreathing1]

@@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.

[@PowerBIPark]

The problem will probably be the last date function. You could try changing that to just [current date] - selected date

[@mkbrown1982]

did you ever get this to work? I'm having the same issue, and I don't quite understand his reply

[@imstillbreathing1]

@@mkbrown1982 no I didn't

[@carloserodriguez2465]

this is great!! Thank you so much for this..

[@PowerBIPark]

No worries!

[@mmunozidata]

Excelent...like always

[@PowerBIPark]

Appreciate it

[@BlakeC341]

Looks great.

[@DarcyWhyte]

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....

[@PowerBIPark]

Sounds great! This is just a peek into some of the stuff we can do :)

[@puddin640]

This video was awesome! Definitely trying this out tomorrow. Do you take office hours? 😂😂

[@PowerBIPark]

Glad you liked it :) I used to do random hours on topmate but I don't really right now :)

[@arbazahmad7177]

Excellent... thank for sharing

[@PowerBIPark]

Welcome 😊

[@amitajain8855]

have you also posted the file which is final made by KPI on power bi

[@PowerBIPark]

I'm thinking about making it available for my patreon supporters, but... this literally tells you how to do it :)

[@rartsar]

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.

[@PowerBIPark]

I have a video for using images in slicers, kzbin.info/www/bejne/eZS4h2BvlN9oq7ssi=Racfkz36vfUvNFck which should take care of the first part :)

[@AdamArzemy]

How do you label moving average on the line?

[@PowerBIPark]

Hey, it's an option called Series labels :)

[@josehuembes5148]

Excellent, I subscribe

[@miguelhg1989]

How do you get that "sugest a visual" window?

[@alono2323]

enable 'on object interaction' settings > preview

[@PowerBIPark]

That's correct, thanks for sharing :)

[@gurvindersingharora5301]

Hello Sir, Great Work. But could you upload videos related Advanced DAX.

[@PowerBIPark]

Maybe in the future :)

[@syedyaseenahmed6787]

Where can we get the data to practice this excercise.

[@PowerBIPark]

Take it from my github, it's linked in the description

[@Somu_Murugan]

Thanks a lot.... Awesome

[@anomolarahul3712]

Such an amazing one..

[@PowerBIPark]

Thanks!

[@markusleucht6603]

this is so good.

[@PowerBIPark]

Glad you think so :)

[@VladimirKozomara]

Thanks for explaining :-D

[@PowerBIPark]

You bet!

[@APG67-q8l]

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,

[@iancao4008]

Amazing visual

[@zaephaer]

Thank you!

[@PowerBIPark]

You're welcome!

[@shabeerahmed6891]

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

[@PowerBIPark]

You have the starter report and a video telling you how to do it, I think that's as good as it gets

[@blaatfanaat]

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?

[@PowerBIPark]

It's pretty simple, you just need to use a field parameter :)

[@mogarrett3045]

that's sick.....thank you

[@PowerBIPark]

Glad you like it!

[@hudsons.araujo6082]

Great!!!!! Topppp

[@jakob2746]

Out of curiousity. Why obscure the data itself? why so protective of this data?

[@PowerBIPark]

A really good question, but why wouldn't you be protective of personal data?

[@naylord5]

Should be illegal to have all this value for free. Thank you very much for sharing! Cheers mate!

[@PowerBIPark]

I might put some of this content into courses in the future - so enjoy it now :)

[@aldozapata5593]

excelente

[@SarahAllen-t5y]

997 Cartwright Inlet

[@Sandra-b4c1r]

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!