KPI Indicators

KPI (Key Performance Indicator) indicators are visuals that show whether a specific metric is meeting its target. They are used to track business performance, monitor goals, and provide quick insights at a glance.

KPI indicators are ideal for metrics like revenue, profit, sales targets, or customer satisfaction.

Components of a KPI

1. Indicator Value – The actual value of the metric being measured (e.g., Total Sales).
2. Target Value – The goal or benchmark the metric is compared against.
3. Trend Axis – Optional. A time-based field (like Date) to show performance over time.

Creating a KPI in Power BI

Step 1: Prepare Measures

Create a measure for the value and target.

Example – Actual Sales

Total Sales = SUM(Sales[Amount])

Example – Sales Target

Sales Target = 100000

Step 2: Add KPI Visual

1. Insert a KPI visual in your report.
2. Drag Total Sales into the Indicator field.
3. Drag Sales Target into the Target Goal field.
4. Drag Date (or another trend axis) into the Trend axis field to show changes over time.

Step 3: Format KPI

• Customize colors for good, bad, and neutral performance.
• Set thresholds for conditional formatting (e.g., red if below 80%, yellow 80–100%, green above target).
• Adjust text size, labels, and alignment for clarity.

Example – Using DAX for Dynamic KPI

You can create dynamic KPI thresholds using DAX:

Sales KPI Status =
SWITCH(
    TRUE(),
    [Total Sales] >= [Sales Target], "Above Target",
    [Total Sales] >= [Sales Target]*0.8, "Near Target",
    "Below Target"
)

• This measure dynamically categorizes performance as Above Target, Near Target, or Below Target.
• Can be used to apply conditional formatting in KPI visuals or cards.

Best Practices

• Use KPI indicators for critical metrics only to avoid clutter.
• Combine KPI visuals with trend lines or supporting visuals for better context.
• Make thresholds clear and aligned with business goals.
• Ensure KPI visuals update dynamically based on slicers or filters.

Conclusion

KPI indicators in Power BI are a powerful way to monitor performance against targets. Using DAX measures, you can make KPI visuals dynamic, interactive, and aligned with business objectives, helping users make quick and informed decisions.