All articles

Design · DAX

Power BI KPI cards: how to make headline numbers people trust

How to design Power BI KPI cards: which measures to show, number formats, comparisons to target or last year, and the DAX behind them. With examples on real data.

7 November 2026·2 min read·Sources listed at the end

Design

The cards at the top of a report are the first thing anyone reads, and often the only thing. A good KPI card answers three questions: how much, compared to what, and is that good?

1. Choose 3–4 measures, not 10

Pick the numbers the reader would ask for first. For a sales report on the practice data:

Card Value
Total Sales 118.7M
Total Profit 16.9M
Profit Margin 14.2%
Units Sold the total of Units Sold

More cards don’t add information; they hide the important ones.

2. Always use a measure

Dragging a column onto a card makes an implicit sum. It works, but you can’t reuse it, name it or control it. Write the measure once:

Total Sales = SUM(financials[Sales])
Total Profit = SUM(financials[Profit])
Profit Margin = DIVIDE([Total Profit], [Total Sales])

DIVIDE returns blank instead of an error when there are no sales, which keeps cards clean when a slicer filters everything out.

3. Format for reading, not for accounting

  • Large numbers: display units in the Format pane (Millions) with one decimal: 118.7M.
  • Percentages: one decimal: 14.2%.
  • Same format for the same measure everywhere.

4. Add a comparison

A number alone means little. 16.9M profit: is that good? Add one comparison:

Sales LY = CALCULATE([Total Sales], SAMEPERIODLASTYEAR(Dates[Date]))
YoY % = DIVIDE([Total Sales] - [Sales LY], [Sales LY])

Show YoY % under the main number, or use the KPI visual or the new Card visual with a reference label. Be careful with partial years: in the practice data, 2013 only has September to December, so a full-year comparison shows huge “growth” that is really a calendar effect. Compare matching months instead.

5. Status color, used honestly

Color the comparison, not the main number: green when above target, red when below. Pair the color with an arrow or a sign (+3.1%, −2.7%) so it still reads without color.

6. A title that changes with the slicer

When a slicer is used, tell the reader what they’re looking at:

Sales Title = "Sales for " & SELECTEDVALUE(financials[Country], "all countries")

Use it as the card’s title with conditional formatting (fx), so the card says “Sales for Canada” when Canada is selected.

Common mistakes

  • Cards showing a count of rows when people expect a sum.
  • Too many decimals: 118,726,350.26.
  • A margin card that averages row margins instead of dividing total profit by total sales. The two give different answers. See average of ratios vs ratio of sums.

Practice it

Numbers people can read has you fix the formats on a real report in our Power BI practice simulator. You write the measures yourself in the DAX basics stage, and every correct measure appears on the dashboard as a card.

Sources

Practice it

Numbers people can read

Ratios as percentages, a heat map instead of a wall of numbers, and the right amount of detail.

Open the lesson

Read next