Power BI Practice Solution ROUND #10 I CUSTOM KPI CARDS

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 https://datatraining.io/powerbi-how-to

--------------------------------
📊 TRAININGS 📊
---------------------------------
Power BI Design 4 Weeks Transformation Program https://my.datatraining.io/pages/powe...

Power BI Essentials https://datatraining.io/powerbilearni...

Business User Training https://datatraining.io/powerbi-busin...

For Custom Trainings and Consulting email directly [email protected]

---------------------------------
⏱️ 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 https://bit.ly/4b453bi
Subscribe https://bit.ly/31MnQGO​
Insta   / howtopowerbi  
LinkedIn   / basdohmen  
TikTok   / how.to.power.bi  
X   / howtopowerbi  
fb   / howtopowerbi  
Threads https://www.threads.net/@howtopowerbi
Newsletter https://datatraining.io/newsletter

---------------------------------
👇 CHECK THIS OUT! 👇
---------------------------------
💻 My gear https://amzn.to/47F21Yc
📚 Power BI books MUST READ! https://amzn.to/3tUfFcj
💡 General books I recommend https://amzn.to/48YNo33
🎶 Music for my videos https://www.epidemicsound.com/referra...
🚀 For growing on YouTube: https://www.tubebuddy.com/bas
🏄 Stuff I use daily https://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