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/powerbihowto
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/powerbibusin...
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