How to Use the KPI Card in Power BI

The KPI card in Power BI is one of the most effective ways to show progress toward a key business goal at a glance. More than just a number on your dashboard, it instantly tells you where you are, where you're supposed to be, and how the trend is looking over time. This guide will walk you through everything you need to know to create, customize, and effectively use the KPI visual in your Power BI reports.

Graphed

Your AI Data Analyst to Create Live Dashboards

Connect your data sources and let AI build beautiful, real-time dashboards for you in seconds.

Build Your First Dashboard

What Is a KPI Card and Why Use It?

A Key Performance Indicator (KPI) is a measurable value that shows how effectively your business is achieving its main objectives. KPIs help teams focus on what matters most. For example, a sales team might track "Monthly Recurring Revenue," while a marketing team might focus on "Cost Per Lead."

The Power BI KPI visual is designed specifically to display this kind of metric. It’s different from a standard Card visual because it includes three key elements in one compact package:

• Indicator: This is the main value, or your current performance (e.g., $1.2M in sales this quarter).
• Target: This is the goal you are measuring against (e.g., your sales target of $1.5M). It provides crucial context.
• Trend Axis: This is a small area chart in the background that shows how the indicator has performed over time (e.g., sales performance over the past 12 months).

The real power of the KPI card is its ability to communicate status with color. It automatically evaluates your indicator against the target and displays a color - typically green if you're on track and red if you're behind - so viewers can assess performance in less than a second.

Preparing Your Data for a KPI Card

Before you can build an effective KPI visual, your data model needs to contain a few key ingredients. Without the right data fields, the KPI card won’t work as intended. Trying to create a KPI without this prep is like trying to bake a cake without any eggs or flour.

At a minimum, you'll need three types of data:

1. The Indicator (or Base Value): This is the main metric you want to track. It must be a calculated value, like a measure. Examples include Total Sales, New Customers, or Average Session Duration. You cannot just drag a raw table column here, it needs to be aggregated (e.g., SUM, AVERAGE, COUNT).
2. The Target Value: This is the goal you're aiming for. It can be a fixed number, a column in one of your tables, or another measure. For example, your sales target could be stored in a separate table or calculated dynamically with DAX.
3. The Trend Axis: To create the background area chart, you must provide a time-based or sequential-based column. This is most commonly a date column, like OrderDate, Month, or Year. This gives your KPI historical context.

For example, a simple sales tracking table in Excel might look something like this:

When you load this into Power BI, you'd create measures like Total Actual Sales = SUM('Sales'[Actual Sales]) and Total Target Sales = SUM('Sales'[Target Sales]).

AI for Data Analysis

Crash Course

Graphed

Free PDF Guide

AI for Data Analysis Crash Course

Learn how to get AI to do data analysis for you — the best tools, prompts, and workflows to go from raw data to insights without writing a single line of code.

Download Free Guide

How to Create Your First KPI Card: A Step-by-Step Guide

With your data prepped, creating the KPI card is straightforward. Let’s walk through the exact steps using our sales data example.

Step 1: Add the KPI Visual to Your Report

First, open your Power BI report canvas. In the Visualizations pane on the right-hand side, find and click the KPI icon. It looks like a small report with a checkmark and an upward trend line. This will add an empty KPI placeholder to your canvas.

Step 2: Assign Your Data Fields

With the new visual selected, look at the field wells in the Visualizations pane. You will see three slots to drag your data into:

• Value: Drag your primary measure here. For our example, we would drag Total Actual Sales. Note: This was formerly called "Indicator."
• Trend axis: Drag your date or sequential column here. We would drag the Date column from our sales table.
• Target: Drag your target measure here. We'll add our Total Target Sales measure.

As you add each field, the visual on your canvas will update. After adding all three, you'll have a fully functional KPI card.

Step 3: Check Your Initial Result

Your new KPI card should now be displaying the most recent metric. You’ll see the large value of Total Actual Sales for the latest date period in your data. Below that, you’ll find the target value. You’ll also see a colored background chart representing the sales trend over time from your Date column.

The card will also show the percentage above or below the target. By default, it could be set to display green or another color due to trends, so check that the color and direction are correctly visually representing your data story.

Customizing Your KPI Card for Maximum Impact

The default KPI card is useful, but its true potential is unlocked through the formatting options. You can tailor it to fit your company’s branding and, more importantly, to tell a clearer story.

Select your KPI card and navigate to the Format your visual tab in the Visualizations pane (the paintbrush icon).

Callout Value and Labels

In the Callout Value section, you can format the main indicator value. This is where you can change the font, text size, and color to make it stand out. The Display units option is also helpful here, letting you automatically format large numbers as thousands (K), millions (M), or billions (B) to save space and improve readability.

Graphed

Your AI Data Analyst to Create Live Dashboards

Connect your data sources and let AI build beautiful, real-time dashboards for you in seconds.

Build Your First Dashboard

Trend Axis Settings

Under the Trend axis section, you can change the visual's direction and color. You can also toggle the trend axis on or off. While you need data in the Trend axis field well for the KPI to work, you can choose to hide the background chart if you prefer a cleaner look. You also have control over the transparency of the background chart, which is useful when laying the card over a colored or image background on your report.

Color Coding: The Heart of the KPI Visual

The most important formatting option is under Color coding. This is where you define the logic that tells Power BI whether your performance is good, neutral, or bad. Inside, you’ll find the Direction setting with a few important options:

• High is good: Select this for metrics like sales, profit, or customer satisfaction scores, where a higher value is better. The card will turn green when your indicator is above the target.
• Low is good: Use this for metrics like expenses, customer churn, or 'Time to Resolution', where a lower value is better. The card will turn green when your indicator is below the target.

Below the direction settings, you can customize the colors for Good color, Neutral color, and Bad color, allowing you to match your company's branding or use intuitive color schemes.

Advanced Tips and Common Pitfalls to Avoid

Ready to level up your KPI cards? Here are a few advanced techniques and common mistakes to watch out for.

Tip 1: Use DAX for Dynamic Targets

Targets aren’t always static numbers. Often, you want to compare your performance to a dynamic value, such as the same period last year or a percentage increase over the previous quarter. This is where DAX (Data Analysis Expressions) comes in.

For example, to set your target as "last year's sales," you could create a measure like this:

Sales Last Year = CALCULATE(
    SUM(Sales[Actual Sales]),
    SAMEPERIODLASTYEAR('Calendar'[Date])
)

You can then drag this new Sales Last Year measure into the Target field well. This creates a more meaningful, context-aware KPI.

AI for Data Analysis

Crash Course

Graphed

Free PDF Guide

AI for Data Analysis Crash Course

Learn how to get AI to do data analysis for you — the best tools, prompts, and workflows to go from raw data to insights without writing a single line of code.

Download Free Guide

Tip 2: Manage Your Time Context Correctly

The value shown on your KPI card reflects the very last data point available along your trend axis. If your trend axis is Date, it shows the total for the final day. If it’s Month Name, it shows the total for the last month. Make sure this is clear to your audience. You can use slicers for Year and Month to let users explore different time periods.

Common Pitfall 1: Incorrect "Direction" Setting

Accidentally setting High is good for an expense metric is a common mistake that can cause major confusion. A report that shows a bright green KPI for soaring company costs will mislead decision-makers. Always double-check that your color-coding logic aligns with the business meaning of the metric.

Pitfall 2: Missing Data Fields

The KPI visual simply won't work correctly without the required data fields. If you forget to add a field to the Trend axis, you'll see a "(Blank)" text where the sparkline chart should be. If you omit the Target, the card loses its core purpose and just displays the indicator value, without context or color coding. Always ensure all three fields – Value, Trend axis, and Target – are populated.

Final Thoughts

Effectively using the KPI visual in Power BI transforms your reports from static data displays into powerful performance monitoring tools. By combining a core metric, its target, and a historical trendline, you give your audience a quick, clear view of what’s important and whether things are moving in the right direction.

Creating these dashboards is immensely valuable, but manually connecting sources and keeping everything up-to-date across platforms can still be a heavy lift. We built Graphed to remove this friction by connecting with all your data sources and allowing you to just ask for what you need. Instead of finding the right visual settings, you can simply type, "Show my total ad spend vs my budget target as a KPI for this month," and instantly get a real-time, shareable dashboard.