Power BI Practice Solution ROUND #10 I CUSTOM KPI CARDS
Vložit
- čas přidán 30. 07. 2024
- In this Power BI Practice round the challenge is to develop CUSTOM KPI CARDS. To solve it, we combine different charts, build sparklines, apply conditional formatting, use icons, and override slicers. The data for this challenge comes from a facebook marketing campaign and focuses on conversion of clicks in enquiries and purchases.
Requirements:
- Build a card visual showing the clickthrough rate.
- Create a measure that returns an upward when the clickthrough rate went up vs previous month.
- Apply conditional formatting to the arrow icon and KPI card. Apply a green colour if the clickthrough rate of the selected month was higher than the previous month and apply red if it was lower.
- Add a measure that returns the previous month value for the clickthrough rate
- Create a sparkline for the development of the clickthrough rate over time. Important is that the sparkline should only go until the selected month.
- Group the items for the custom card in the selection pane and arrange them in the right order.
- Replicate the previous steps for clicks to enquiry conversion and enquiries to purchase conversion.
Share your approach, questions, feedback below or on Twitter using the hashtag #PowerBIPractice and tag @HowToPowerBI
Download file here datatraining.io/powerbi-how-to
--------------------------------
📊 TRAININGS 📊
---------------------------------
Power BI Design 4 Weeks Transformation Program my.datatraining.io/pages/powe...
Power BI Essentials datatraining.io/powerbilearni...
Business User Training datatraining.io/powerbi-busin...
For Custom Trainings and Consulting email directly support@datatraining.io
---------------------------------
⏱️ TIMESTAMPS ⏱️
---------------------------------
0:00 Intro
0:49 Showing the KPI value on a card
1:18 Showing a trend icon on a card
3:22 Creating the frame, title, and background for a custom KPI card
4:40 Adding a comparison text to a custom KPI card
6:12 Applying conditional formatting to a KPI card
7:53 Creating a sparkline
10:33 Overwriting a date slicer
15:36 Finalizing the custom KPI card
17:53 End
---------------------------------
😍 JOIN 😍
----------------------------------
Join bit.ly/4b453bi
Subscribe bit.ly/31MnQGO
Insta / howtopowerbi
LinkedIn / basdohmen
TikTok / how.to.power.bi
X / howtopowerbi
fb / howtopowerbi
Threads www.threads.net/@howtopowerbi
Newsletter datatraining.io/newsletter
---------------------------------
👇 CHECK THIS OUT! 👇
---------------------------------
💻 My gear amzn.to/47F21Yc
📚 Power BI books MUST READ! amzn.to/3tUfFcj
💡 General books I recommend amzn.to/48YNo33
🎶 Music for my videos www.epidemicsound.com/referra...
🚀 For growing on CZcams: www.tubebuddy.com/bas
🏄 Stuff I use daily amzn.to/3HqfMQ2
* Above are affiliate links, which means at no additional cost to you, if you make a purchase using these links we will receive a small commission. It supports us and helps us to continue making more How to Power BI videos!
Thanks for being a part of this channel and all your support! 💪 🙏
#HowToPowerBI #PowerBI #DataTraining
#powerbidesktop #powerbitraining #powerbideveloper #DAX - Věda a technologie
Another quality “just in time” video I’ve bookmarked because I need it for my own project! Thanks!
so nice to hear you're implementing it! 😃 👊
This helped me immensely. I was trying to use the default KPI visual but couldn't make the trend work properly and it wouldn't look as good anyway. Tks for the content, great help!
Im 3 years late, but this was amazing! it is exactly what i needed.
really easy to follow; i just started wit PBI and these videos are great! a bit of help. i follow exactly the creation of the icon measures but the arrow don’t change. alway point up. any suggestions?
Thank you for the video. I manage to build the same KPI in your pbix file. It was not fast - lot of details but now I can. Thanks. Your vidoes are very interesting
awesome! 😃👊 second time will be a lot faster though!
Thanks for sharing! 🫡🫡
Ingenious! Thank you for sharing!
thank you Angela! 😊
This is excellent. I will be using this approach to build all future KPI's. The lack of flexibility with the default KPI visual makes it almost useless.
Right? I'm new to PowerBI but you really have to abuse the shit out of the KPI visuals if you even want to have an drill through ability.
Jai ho guru ji ki.🎉❤
Hello just a quick question looks like that on the new version of Power Bi the conditional format for text is not possible Version: 2.109.642.0 64-bit (September 2022), any idea how we can go around. thanks
Nice video! Very useful.
In 3:38, in the text box, many times a red line appears. And some of them it remains for ever. Do you know how to deal with it? Thanks!
that is auto spellcheck, you can't turn it off. However if you go to another page and then back it isnt there - also not when you publish the report.
Woow really got to learned very useful stuff thank you
Question how the year +month slicer showing year +month name on slicer header is it by default or u did some formating to get that.
You can pull the two fields Year and Month to the slicer and you get Year Month. If you click View more there is a link to the PBIX file where you can see how it done.
@@AmdiSilword thank you
you can create a date hierarchy and place it on a slicer. Then in the top right corner of the slicer click on v and choose dropdown list. That's it 🙂
Good one 👍
Thanks ✌️
I really like your videos 😍 they are very helpful for me that I'm a newbie on pwbi. Can you make a video to explain how to compare this month Vs previous month? I mean,I can't understand how to say to the bi: each time I select a month you must compare it Vs previous month. Thanks
thanks Angelo! Happy to hear they help! You can do it as follows:
- Measure1 Total Sales: SUM(Sales)
- Measure2 Total Sales Previous Month: CALCULATE([Total Sales], DATEADD( dimDate[Date], -1, MONTH ))
- Measure3 Total Sales Month over Month: [Total Sales] - [Total Sales Previous Month]
While starting of with DAX it might be helpful at the beginning to also use the quick measures
Hope that helps
Big fan sir, you could let me know how to apply above logic for mom profit % change
You just have to appreciate the video editing
Oh so nice you mention that... the editing takes longer than the prep + recording 😅
@@HowtoPowerBI It is very obvious 😂
Hi Bas,
Can we expect other Practice Rounds? in future ??
right now not in planning:)
Can you please tell me why this wont work for me on my end?
Liq - MoM Icon =
VAR IconPositive = UNICHAR(9650)
VAR IconNegative = UNICHAR(9660)
VAR Result =
IF(
SUM(iBodyLibrary[Liquid Cost to Refinish Labour Sales]>[Previous Period Liq],
IconPositive,
IconNegative
)
RETURN
Result
Missing closing bracket for the sum function
Your a legend!