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

--------------------------------
📊 TRAININGS 📊
---------------------------------

---------------------------------
⏱️ 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 😍
----------------------------------

---------------------------------
👇 CHECK THIS OUT! 👇
---------------------------------

* 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

[famousjamous]

Another quality “just in time” video I’ve bookmarked because I need it for my own project! Thanks!

[jeremymccubbin]

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.

[slowchrno]

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!

[AmdiSilword]

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

[ryner]

Im 3 years late, but this was amazing! it is exactly what i needed.

[chinesejs]

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?

[carax]

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

[totvabe]

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!

[mohdmuzammil]

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.

[catalinatobonfernandez]

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

[hiteshjoshi]

Big fan sir, you could let me know how to apply above logic for mom profit % change

[BolajiBI]

You just have to appreciate the video editing

[madhusudhan]

Hi Bas,
Can we expect other Practice Rounds? in future ??

[mitchelboyle]

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