Power BI: Create a dynamic KPI indicator with icons

Short answer

A dynamic KPI indicator with icons in Power BI shows the status of performance metrics at a glance via visual symbols such as a green tick, orange warning, or red cross. You create this via a DAX measure that compares the KPI value with threshold values and categorises them. A calculated column then links an icon to each category. This makes dashboards immediately more insightful and helps decision-makers draw the right conclusions faster.

A dynamic KPI indicator with icons helps you see the status of important performance metrics at a glance. In this article you'll learn how to create such a dynamic KPI indicator in Power BI, making your dashboards immediately more insightful and interactive.

A dynamic KPI indicator with icons helps you see the status of important performance metrics at a glance. In this article you’ll learn how to create such a dynamic KPI indicator in Power BI, making your dashboards immediately more insightful and interactive. This is valuable for BI teams that want to make quick decisions based on visual signals.

What you need

A dataset with KPI values or measures
A column with threshold values or criteria for the indicator
Power BI Desktop or access to the online environment

Step 1: Create a measure for the KPI status

The first step is defining a measure that determines the status of your KPI, for example ‘Good’, ‘Warning’, or ‘Bad’. You do this with a DAX formula that compares the value with predetermined thresholds.

Add a new measure in Power BI Desktop with for example this DAX code:

KPI Status =
SWITCH(
    TRUE(),
    [KPI Value] > 80, "Good",
    [KPI Value] > 50, "Warning",
    "Bad"
)

This measure classifies the KPI value into three categories, forming the basis for the dynamic indicator.

Step 2: Add a column with icons via a calculated column

Create a new calculated column that shows a corresponding icon (Unicode or emoji) based on the KPI status. This makes the indicator visually appealing and clear.

Use for example this DAX formula:

KPI Icon =
SWITCH(
    [KPI Status],
    "Good", "✔️",
    "Warning", "⚠️",
    "Bad", "❌",
    ""
)

This column shows a green tick, a warning sign, or a red cross, depending on the status.

Step 3: Visualise the dynamic KPI indicator in your report

Use a table or matrix visualisation and add the KPI value, KPI status, and KPI icon. Make sure the column with icons is displayed as text so the symbols are visible.

You can also use a card visualisation and combine the icon column with the value for a compact display. This makes your dashboard clear and interactive.

Tips & common mistakes

Use clear threshold values that align with your business goals for relevant KPI classifications.
Check the display of icons in different browsers and devices to ensure consistency.
Avoid too many categories to keep the indicator clear.
Use colours in combination with icons for additional visual support.

Example / mini use case

Suppose you have a sales dashboard with a KPI for monthly revenue. With this dynamic KPI indicator you immediately see which regions are performing above expectations (green tick), which regions need attention (orange warning), and which are falling behind (red cross). This speeds up decision-making and makes your report more powerful.

Conclusion

With these simple steps you create a dynamic KPI indicator in Power BI that immediately makes your dashboards more insightful. Try it yourself and discover how visual signals strengthen your analyses. Want to work directly in the online environment? That works too!

Our tip: Define KPIs together with the department that uses them, not just with IT or management. This ensures that the right metrics are tracked and the dashboard is actually used.

Frequently asked questions

How do I create a dynamic KPI indicator with icons in Power BI?

First create a DAX measure that categorises the KPI value using the SWITCH(TRUE(),...) function, such as 'Good', 'Warning', or 'Bad'. Then add a calculated column that assigns a Unicode symbol or emoji to each row based on the status. Add both fields to a table or matrix visualisation and make sure the icon column is displayed as text. This way you can see the KPI status per row directly via a recognisable symbol next to the numeric value.

Which DAX formula do I use for KPI status classification in Power BI?

Use the SWITCH(TRUE(),...) function for a clear and extensible classification. An example: KPI Status = SWITCH(TRUE(), [KPI Value] > 80, "Good", [KPI Value] > 50, "Warning", "Bad"). Adjust the threshold values based on your business goals. SWITCH(TRUE()) evaluates each condition from top to bottom and returns the first one that is true. This is more efficient and readable than nested IF statements with three or more categories.

What common mistakes should I avoid with KPI indicators in Power BI?

The most common mistakes are: creating too many categories making the indicator confusing, setting threshold values that do not align with actual business goals, icons that are not displayed correctly in certain browsers or devices (always test this), and using a calculated column where a measure would be better. Set threshold values in consultation with the department that uses the KPIs, so that the classification aligns with daily practice.