KPI Cards & Targets
Power BI · Dashboards & Reports
Theory
Headline numbers are usually shown with the Card visual or the KPI visual. The Card visual shows one or several values and can add reference labels such as a target; it replaced the older single and multi-row card visuals, which are now legacy. The KPI visual shows a value, a target and a trend with a coloured indicator. Behind them sit simple measures: an actual, a target and a variance. Targets often come from a separate table, for example the unpivoted Targets table with Region, Month and Target, related to the same dimensions as Sales.
For Q1 2024 in the sample model, North's actual sales are ₹2,700 (January ₹1,200 + February ₹1,500) against a target of ₹3,700 (1,000 + 1,500 + 1,200), a variance of −₹1,000 or −27.0%. West's actual is ₹2,400 against ₹2,700, −11.1%. Writing Variance % with DIVIDE avoids errors when the target is blank, and formatting the measure as a percentage keeps the card readable. Conditional formatting can then colour the value red or green.
Why we use it
Leaders read the top of the page first. Clear KPI cards with targets answer 'are we on track?' instantly instead of leaving readers to do mental maths.
When to use it
Use cards for single headline values, the KPI visual when a target and trend axis are available, and a table with variance columns when comparing many items. Keep targets in their own table rather than hard-coding them in measures.
How it works
- Need a headline number
- Write Actual and Target measures
- Compute Variance and Variance % with DIVIDE
- Is there a trend axis and a target? Yes: Use the KPI visual. No: Use a Card or a table with variance columns.
- Readers see performance at a glance
Syntax
Card: Visualizations → Card → Values: [Measure]; Format → Reference labels for a target
KPI visual wells: Value | Target | Trend axis
Variance % = DIVIDE([Actual] - [Target], [Target])
Measure tools → Format: Percentage / CurrencyExample
Total Target = SUM(Targets[Target])
Variance = [Total Sales] - [Total Target]
Variance % = DIVIDE([Variance], [Total Target])
// Q1 2024 table visual by Region:
// North 2,700 3,700 -1,000 -27.0%
// West 2,400 2,700 -300 -11.1%Key points
- Card = one or more headline values; KPI visual = value, target and trend
- Keep targets in a separate table linked to dimensions
- Use DIVIDE for percentages to handle blank targets
- Format measures as currency or percentage
- Combine with conditional formatting for on/off-track colours