KPI visual in Power BI - Cheat Sheet & Quick Revision

Recall & Review

beginner

What does KPI stand for in Power BI?

KPI stands for Key Performance Indicator. It is a visual that shows progress toward a measurable goal.

beginner

What are the three main components of a KPI visual in Power BI?

The three main components are: 1) Indicator (the actual value), 2) Target (goal value), and 3) Trend axis (time or categories to show progress).

beginner

How does the KPI visual help in business decision making?

It quickly shows if a key metric is on track or off track by comparing actual values to targets, helping users focus on important goals.

intermediate

Which data type is best suited for the 'Trend axis' in a KPI visual?

A date or time data type is best because it shows how the indicator changes over time.

intermediate

Can you use a KPI visual without setting a target value?

No, the KPI visual requires a target value to compare the actual indicator against. Without a target, it cannot show progress or status.

What does the 'Indicator' in a KPI visual represent?

A The time period

B The goal or target value

C The color of the visual

D The actual value being measured

The Indicator is the actual value you want to track, such as sales or revenue.

Which field is optional in a KPI visual?

A Trend axis

B Target

C All are required

D Indicator

The Trend axis is optional but recommended to show progress over time.

What color usually indicates a KPI is on target?

A Red

B Yellow

C Green

D Blue

Green typically means the KPI is meeting or exceeding the target.

If the actual value is below the target, what does the KPI visual usually show?

A Green color

B Red color

C No color

D Blue color

Red color usually signals the KPI is below the target and needs attention.

Which visual type is best for showing progress toward a goal in Power BI?

A KPI visual

B Bar chart

C Pie chart

D Table

The KPI visual is designed specifically to show progress toward a goal.

Explain how to set up a KPI visual in Power BI and what each part represents.

Think about what you want to measure, the goal, and how it changes over time.

Describe why using a KPI visual can help a business team stay focused on important goals.

Imagine you are a manager checking if sales are meeting targets.