Forum Discussion

TLW_STL's avatar
TLW_STL
Helper I
1 year ago
Solved

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?
Need Help
Show and Tell
Tips and Tricks
  • FarhanJeelani's avatar
    FarhanJeelani
    1 year ago

    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 Trend

    Trend_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.

FarhanJeelani's avatar
FarhanJeelani
Super User
1 year ago

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 Trend

Trend_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.