The Best KPI Cards In Power BI
ฝัง
- เผยแพร่เมื่อ 13 ก.ย. 2024
- How to make the best KPI Card in Power BI
Check out PART 2 : • This Visual CHANGES fo...
🔥 PBIX here➡️: github.com/Pow...
🔥 Gustaw's Original Post: www.linkedin.c...
If you'd like to see more videos like this,
consider supporting the channel:
/ powerbipark
/ injae-park
Thanks for taking the time to watch this video.
#PowerBI #DataAnalytics #BusinessIntelligence #powerquery
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!
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 :)
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 :)
Congratulations on more fabulous content. You have a remarkable talent for making complex topics easily understandable! thanks so much!
Wow, thank you!
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 :)
man, this is GOLD. Solved my issue here !!! Thank you very much
Nice! Glad it helped someone immediately x)
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!
This video is like a new level from you! Thanks a lot for your valuable content.
Thanks man, I appreciate it :]
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.
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 :)
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
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
Great stuff and so many useful tips!!!
Glad you think so!
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 :)
Excellent, I subscribe
Amazing visual
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!
That was good learning. Thank You
Glad it was helpful!
Awesome content! Thanks for sharing!
Thanks for watching
Thanks for sharing! Very insightful!
Thanks! Glad to see you making videos too :)
Handy insights!. Thanks for sharing
Glad it was helpful!
Thanks for sharing! You are a Star!
Appreciate you!
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 :)
Great breakdown - thanks!
Very welcome!
This is sick 🔥 Thanks Injae
Cheers :)
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 :)
this is great!! Thank you so much for this..
No worries!
Great video Injae.
Thank you!
Excellent... thank for sharing
Welcome 😊
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 so good.
Glad you think so :)
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 :)
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?
Thank you!
You're welcome!
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.🥳
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
Thanks for explaining :-D
You bet!
Excelent...like always
Appreciate it
that's sick.....thank you
Glad you like it!
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 :)
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?
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
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 :)
Such an amazing one..
Thanks!
How do you label moving average on the line?
Hey, it's an option called Series labels :)
How do you get that "sugest a visual" window?
enable 'on object interaction' settings > preview
That's correct, thanks for sharing :)
Where can we get the data to practice this excercise.
Take it from my github, it's linked in the description
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
Davis Sandra Robinson Carol Lee Scott