How to Create KPI Visual in Power BI: Step-by-Step Guide

To create a KPI visual in Power BI, select the KPI visual icon from the Visualizations pane, then drag a measure to the Indicator field, a target measure to the Target goals field, and a date or category to the Trend axis. This visual shows your key metric, target, and trend in a simple, clear format.

Syntax

The KPI visual in Power BI requires three main fields:

• Indicator: The main measure you want to track (e.g., sales amount).
• Trend axis: A date or category field to show the trend over time.
• Target goals: The target or goal measure to compare against the indicator.

These fields create a visual that compares actual performance to a target and shows the trend.

plaintext

KPI Visual Fields:
- Indicator: [Measure] (e.g., Total Sales)
- Trend axis: [Date] (e.g., Order Date)
- Target goals: [Measure] (e.g., Sales Target)

Example

This example shows how to create a KPI visual to track total sales against a sales target over months.

plaintext

1. Create two measures in Power BI Desktop:

Total Sales = SUM(Sales[Amount])
Sales Target = 50000

2. Add a KPI visual from the Visualizations pane.
3. Drag <code>Total Sales</code> to the Indicator field.
4. Drag <code>Order Date</code> (month) to the Trend axis.
5. Drag <code>Sales Target</code> to the Target goals field.

The KPI visual will display total sales, compare it to the target of 50,000, and show the sales trend by month.

Output

A KPI visual showing the current total sales value, a target line at 50,000, and a trend line of sales over months.

Common Pitfalls

Common mistakes when creating KPI visuals include:

• Not using a numeric measure for the Indicator or Target goals fields.
• Using a non-date or non-categorical field for the Trend axis, which breaks the trend line.
• Forgetting to create a target measure or using a static number directly in the Target goals field without a measure.
• Using a date field without proper hierarchy, causing confusing trends.

Always ensure your data types match the KPI visual requirements.

plaintext

Wrong:
- Dragging a text field to Indicator.
- Using a text field as Trend axis.

Right:
- Indicator: Numeric measure like SUM(Sales[Amount])
- Trend axis: Date field like Sales[Order Date]
- Target goals: Numeric measure or constant measure

Quick Reference

Field	Description	Example
Indicator	Main measure to track	Total Sales = SUM(Sales[Amount])
Trend axis	Date or category for trend	Order Date (Month)
Target goals	Goal or target measure	Sales Target = 50000

Key Takeaways

Use numeric measures for Indicator and Target goals fields in the KPI visual.

Trend axis should be a date or categorical field to show meaningful trends.

Create measures for targets instead of hardcoding numbers directly.

KPI visuals clearly show performance against goals with trend context.

Avoid using text fields in numeric KPI visual roles to prevent errors.