KPI visual in Power BI - Step-by-Step Guide

Introduction

A KPI visual shows a key number that measures success, like sales or profit. It helps you quickly see if you are meeting your goals by comparing actual results to targets.

When you want to show monthly sales compared to the sales target on a dashboard

When you need to track if customer satisfaction scores meet a set goal

When you want to highlight if expenses are under or over budget

When you want a simple visual to show progress toward a yearly revenue goal

When you want to quickly spot if a key metric is improving or declining

Steps

Step 1: Click

- Visualizations pane

The list of available visuals appears

Step 2: Select

- KPI visual icon in the Visualizations pane

A blank KPI visual placeholder appears on the report canvas

Step 3: Drag

- The measure field (e.g., Total Sales) from Fields pane to the 'Indicator' well in the Visualizations pane

The KPI visual shows the current value of the measure

Step 4: Drag

- The measure or field representing the target value (e.g., Sales Target) to the 'Target goals' well

The KPI visual shows a comparison between actual and target values

Step 5: Drag

- The date or time field to the 'Trend axis' well

The KPI visual displays a trend line showing changes over time

Step 6: Resize and position

- The KPI visual on the report canvas

The visual fits well with other report elements and is easy to read

Before vs After

Before

Report canvas has no KPI visual; only raw sales data is shown in tables

After

Report canvas shows a KPI visual with current sales of $50,000, target sales of $60,000, and a trend line over the last 6 months

Settings Reference

Indicator

📍 Visualizations pane > Fields section > Indicator well

Shows the main value to track, like sales or profit

Default: None

Target goals

📍 Visualizations pane > Fields section > Target goals well

Sets the goal or target to compare the indicator against

Default: None

Trend axis

📍 Visualizations pane > Fields section > Trend axis well

Shows how the indicator changes over time

Default: None

Data colors

📍 Format pane > Data colors

Changes colors to highlight good or bad performance

Default: Green for positive, red for negative

KPI indicator

📍 Format pane > KPI indicator

Shows or hides the indicator value

Default: On

Common Mistakes

Not adding a target value to the KPI visual

Without a target, the KPI cannot show if performance is good or bad

Always add a target measure or constant to the 'Target goals' well

Using a non-date field in the Trend axis

The trend line will not display correctly without a proper time field

Use a date or time field in the Trend axis well to show changes over time

Making the KPI visual too small

The numbers and trend line become hard to read

Resize the visual to a size where text and lines are clear

Summary

KPI visuals show a key number compared to a target to quickly assess performance

Add an indicator, target, and trend axis to create a meaningful KPI visual

Use clear colors and proper sizing to make the KPI easy to understand

Practice

1. What is the main purpose of a KPI visual in Power BI?

easy

A. To show a single important number with trend and target

B. To display detailed tables of data

C. To create complex data models

D. To write DAX formulas

Solution

1. Step 1: Understand KPI visual purpose

   KPI visuals focus on showing one key number that matters most for quick insights.

2. Step 2: Compare options

   Options A, B, and C describe other Power BI features, not KPI visuals.

3. Final Answer:

   To show a single important number with trend and target -> Option A

4. Quick Check:

   KPI visual = single key number with trend [OK]

Hint: KPI = one key number with trend and target [OK]

Common Mistakes:

• Confusing KPI with tables or charts
• Thinking KPI shows multiple numbers
• Assuming KPI is for data modeling

2. Which of the following is the correct way to add a KPI visual in Power BI?

easy

A. Write a DAX formula named KPI()

B. Select the KPI visual icon from the Visualizations pane

C. Use the Table visual and rename it KPI

D. Add a slicer and set it to KPI mode

Solution

1. Step 1: Identify how to add visuals

   Power BI lets you add visuals by selecting icons from the Visualizations pane.

2. Step 2: Confirm KPI visual icon usage

   The KPI visual has its own icon; you do not write DAX or rename other visuals.

3. Final Answer:

   Select the KPI visual icon from the Visualizations pane -> Option B

4. Quick Check:

   Add KPI visual = select icon [OK]

Hint: Add visuals by clicking icons in Visualizations pane [OK]

Common Mistakes:

• Trying to create KPI by DAX formula alone
• Renaming other visuals to KPI
• Using slicers to create KPI visuals

3. Given a KPI visual showing Sales Amount with a target of 100000, if the actual sales are 120000, what color and arrow direction will the KPI show by default?

medium

A. Green color with upward arrow

B. Yellow color with sideways arrow

C. Red color with downward arrow

D. Blue color with upward arrow

Solution

1. Step 1: Understand KPI color and arrow logic

   When actual value exceeds target, KPI shows green color and upward arrow indicating good performance.

2. Step 2: Apply to given values

   Actual sales 120000 > target 100000, so KPI shows green and upward arrow.

3. Final Answer:

   Green color with upward arrow -> Option A

4. Quick Check:

   Actual > Target = Green + Up arrow [OK]

Hint: Actual above target = green and up arrow [OK]

Common Mistakes:

• Confusing red with good performance
• Thinking arrow points down when above target
• Assuming yellow color for above target

4. You created a KPI visual but it shows no trend line. What is the most likely reason?

medium

A. The KPI visual does not support trend lines

B. You forgot to set the target value

C. You did not add a Trend axis field

D. You used a table visual instead of KPI

Solution

1. Step 1: Check KPI visual requirements

   KPI visuals need a Trend axis field to show the trend line over time or categories.

2. Step 2: Identify missing field

   If no trend line appears, likely the Trend axis field was not added.

3. Final Answer:

   You did not add a Trend axis field -> Option C

4. Quick Check:

   No trend line = missing Trend axis field [OK]

Hint: Add Trend axis field to show trend line [OK]

Common Mistakes:

• Assuming target value controls trend line
• Thinking KPI visual cannot show trends
• Using wrong visual type

5. You want to create a KPI visual that shows monthly sales progress with a target line and color changes for above or below target. Which steps should you follow?

hard

A. Add Sales to Filters, Date to Target goals, Target to Indicator

B. Add Date to Indicator, Sales to Trend axis, Target to Filters

C. Add Target to Indicator, Sales to Trend axis, Date to Legend

D. Add Sales measure to Indicator, add Date to Trend axis, add Target measure to Target goals

Solution

1. Step 1: Assign fields correctly in KPI visual

   Indicator shows the main value (Sales), Trend axis shows time (Date), Target goals show the target measure.

2. Step 2: Verify correct field placement

   Add Sales measure to Indicator, add Date to Trend axis, add Target measure to Target goals places Sales in Indicator, Date in Trend axis, and Target in Target goals, enabling progress and color changes.

3. Final Answer:

   Add Sales measure to Indicator, add Date to Trend axis, add Target measure to Target goals -> Option D

4. Quick Check:

   Indicator=Sales, Trend=Date, Target=Target [OK]

Hint: Indicator=Value, Trend=Time, Target=Goal for KPI [OK]

Common Mistakes:

• Mixing up Indicator and Trend axis fields
• Putting target in filters instead of Target goals
• Using wrong fields for legend or filters