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
- Create card visualizations, Microsoft Learn
- DIVIDE function (DAX), Microsoft Learn
- SAMEPERIODLASTYEAR function (DAX), Microsoft Learn