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

  1. Need a headline number
  2. Write Actual and Target measures
  3. Compute Variance and Variance % with DIVIDE
  4. Is there a trend axis and a target? Yes: Use the KPI visual. No: Use a Card or a table with variance columns.
  5. 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 / Currency

Example

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

Power BI topics

Power BI Introduction

Getting Data

Power Query (Data Transformation)

Data Modeling

DAX (Data Analysis Expressions)

Data Visualization

Dashboards & Reports

Power BI Service

Advanced Features

Projects & Case Studies

Interview & Certification

Advanced DAX & Time Intelligence

T
Tech Town
Log InSign Up Free
Home SQL Python DSA Power BI Snowflake Databricks Spark Gen AI Practice Problems Contest Blog

Power BI Dashboards & DAX

Learn data visualization and interactive dashboards step-by-step. Click any topic in the sidebar to open it right here.

{{ sectionCount }}
Sections
{{ topicCount }}
Topics
Free
Forever
Hands-on practice Practice DAX Online 250 business scenarios on a star schema — write a measure and compare your visual with the expected one. Start practising →
Section {{ sec.num }}

{{ sec.label }}

Power BI  /  {{ current.sectionLabel }}  /  {{ current.name }}

{{ current.name }}

Theory

{{ current.def }}

Why we use it

{{ rich.why }}

When to use it

{{ rich.when }}

Diagram

{{ rich.dg.caption }}

{{ tb.title }}
{{ c.v }}
{{ rich.dg.op }}
➜
{{ rich.dg.output.title }}
{{ c.v }}
{{ nd.label }}
{{ nd.sub }}
{{ nd.label }}
{{ nd.sub }}
{{ rich.dg.left.title }}
{{ it }}
{{ rich.dg.right.title }}
{{ it }}
On screen — where to click

{{ rich.ui.title }}

{{ u.text }}
  1. {{ st.n }}{{ st.text }}
{{ rich.ui.title }}
{{ u.text }}
Flowchart — how it works
{{ nd.text }}
{{ nd.text }}
◇ {{ nd.text }}
Yes → {{ nd.yes }}
No → {{ nd.no }}
Syntax / Where to find it
{{ current.syntax }}
Example
{{ current.example }}
What You'll Learn — click to check off
  • {{ pt.mark }} {{ pt.text }}

Share this topic