Forum Discussion
KPIs & Conditional Formatting
Is it possible to create a Card that can include KPI icons, such as up arrow (green) and down arrow (red) without having to create a lengthy Dax calculation?
Hi TLW_STL ,
The KPI visual in Power BI does not support built-in icons, but you can create a custom KPI card with conditional formatting.
Steps:
Create a Measure for TrendTrend_Indicator = IF([KPI_Measure] > 0, "▲", IF([KPI_Measure] < 0, "▼", "-"))Change Colors using Conditional Formatting
Select the Card visual.
Click on the "Format" pane (paint roller icon).
Expand Data Label > Conditional Formatting.
Set Green for Positive and Red for Negative.Also , you can check below link:
https://www.youtube.com/watch?v=V-kFHYhiVvw
Please mark this post as solution if it helps you. Appreciate Kudos.
3 Replies
Hi TLW_STL ,
The KPI visual in Power BI does not support built-in icons, but you can create a custom KPI card with conditional formatting.
Steps:
Create a Measure for TrendTrend_Indicator = IF([KPI_Measure] > 0, "▲", IF([KPI_Measure] < 0, "▼", "-"))Change Colors using Conditional Formatting
Select the Card visual.
Click on the "Format" pane (paint roller icon).
Expand Data Label > Conditional Formatting.
Set Green for Positive and Red for Negative.Also , you can check below link:
https://www.youtube.com/watch?v=V-kFHYhiVvw
Please mark this post as solution if it helps you. Appreciate Kudos.
TLW_STL ,
you can't add icon on the same visual instead you can create measure and use that to visualize icons on another visual which you can resize and group it with your original card visual to look like one visual. And for your reference below link for your refrence. https://community.fabric.microsoft.com/t5/Desktop/FORMAT-icon-set-for-use-in-a-data-card/m-p/811692Hi TLW_STL,
Thank you for reaching out to Microsoft Fabric Community.
Thank you manikumar34 and FarhanJeelani for the prompt response.
As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided by the super user resolved your issue? or let us know if you need any further assistance.
If our super user response resolved your issue, please mark it as "Accept as solution" and click "Yes" if you found it helpful.Thanks and regards,
Anjan Kumar Chippa
