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 [ Ссылка ]
--------------------------------
📊 TRAININGS 📊
---------------------------------
Power BI Design 4 Weeks Transformation Program [ Ссылка ]
Power BI Essentials [ Ссылка ]
Business User Training [ Ссылка ]
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 [ Ссылка ]
Subscribe [ Ссылка ]
Insta [ Ссылка ]
LinkedIn [ Ссылка ]
TikTok [ Ссылка ]
X [ Ссылка ]
fb [ Ссылка ]
Threads [ Ссылка ]
Newsletter [ Ссылка ]
---------------------------------
👇 CHECK THIS OUT! 👇
---------------------------------
💻 My gear [ Ссылка ]
📚 Power BI books MUST READ! [ Ссылка ]
💡 General books I recommend [ Ссылка ]
🎶 Music for my videos [ Ссылка ]
🚀 For growing on YouTube: [ Ссылка ]
🏄 Stuff I use daily [ Ссылка ]
* 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
![](https://i.ytimg.com/vi/luEsXF_WzwQ/maxresdefault.jpg)