How to Find KPI in Power BI

Spotting the KPI visual in Power BI can feel like a tricky game of 'I spy,' but it’s actually one of the most powerful and straightforward tools on the platform. This powerhouse visual does more than just show a number, it tells a story about your performance in a single glance. In this tutorial, we'll walk through exactly where to find the KPI visual, how to configure it correctly with your data, and a few tips to make it a central, insightful part of your reports.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

What Exactly is a KPI Visual (And Why Use It)?

Before we go hunting for it, let's quickly clarify what we're looking for. A Key Performance Indicator (KPI) is a measurable value that shows how effectively a company is achieving key business objectives. The KPI visual in Power BI is designed specifically to track these critical numbers.

You might be thinking, "Can't I just use the Card visual to show a number?" You can, but you'd be missing the most useful part. A Card shows you a single value, but a KPI visual provides three crucial pieces of information at once:

• The Indicator: The actual value you're measuring (e.g., $150,000 in monthly sales).
• The Target: The goal you were trying to hit (e.g., a sales target of $140,000).
• The Trend: A small background chart showing performance over time (e.g., daily sales over the past month).

In one simple box, it answers not just "What did we do?" but also "How does that compare to our goal?" and "Which direction are we heading?" That immediate context is what makes it so valuable for at-a-glance performance monitoring.

Finding and Adding the KPI Visual to Your Report

Alright, let's get down to business. Locating and adding the KPI visual to your report canvas takes just a few clicks. It’s a native visual, so there’s nothing extra to install.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Step 1: Open Your Power BI Desktop Report

Start by opening the Power BI report where you want to track your key metric. Click on an empty space on your report canvas to make sure you don't have another visual selected.

Step 2: Go to the Visualizations Pane

Look to the right side of your screen for the Visualizations pane. This is the menu filled with all the different chart and graph icons you can use to build your report. It's your toolbox for turning data into dashboards.

Step 3: Select the "KPI" Icon

Now, scan the grid of icons for the KPI visual. It’s officially named "KPI" and the icon often looks like a little scorecard or a graph with a checkmark and an 'x'.

If you hover your mouse over the icons, a tooltip will appear showing the name of each visual. Once you find it, simply click it. A blank KPI visual placeholder will appear on your report canvas, ready for you to add your data.

Pro Tip: If you have a lot of visual types, you can use the search bar at the top of the Visualizations pane to find it quickly. Just start typing "KPI" and it will pop right up.

Configuring Your KPI: The Three Essential Fields

A blank KPI visual isn't much use. To bring it to life, you need to provide it with three pieces of data. Once you select the visual, you’ll see the three corresponding fields appear in the Visualizations pane: Indicator, Trend axis, and Target goals.

Let's use a common example: tracking monthly online store revenue against a target.

Your data might look something like this:

• A table with daily sales data, including a [Revenue] column and an [OrderDate] column.
• Another table (or column) containing your [RevenueTarget] for each month.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

1. Drag Your Main Metric into the "Indicator" Field

The Indicator is the current value you're measuring. This is the "what" of your KPI. In our example, this is our total revenue.

From your Fields pane, find your [Revenue] field and drag it into the "Indicator" box. Power BI will typically default to summarizing it (e.g., Sum of Revenue).

Indicator <- Sales[Revenue]

Your visual will now show a single large number, but the magic hasn't happened yet.

2. Drag Your Date/Time Column into the "Trend Axis" Field

The Trend axis tells Power BI how to plot the small background chart that shows performance over time. This field must be a date or a time/date-sequential field.

Find your [OrderDate] field and drag it into the "Trend axis" box.

Trend axis <- Sales[OrderDate]

Now, you should see a small chart appear behind your main number, illustrating how your indicator (revenue) has performed over the date range selected.

3. Drag Your Goal into the "Target Goals" Field

The Target is the goal you are measuring your indicator against. A KPI without a target is just data, not a performance indicator.

Find your [RevenueTarget] field and drag it into the "Target goals" box.

Target goals <- Targets[RevenueTarget]

With this final piece, your KPI visual comes alive! You'll see:

• Your main indicator number.
• The target goal written below it.
• An automatic calculation showing the percentage or value distance from the goal.
• Color-coding (usually green for on-target, red for off-target) to give you an instant visual cue.

Customizing Your KPI for Better Readability

The default KPI is good, but a little formatting can make it great. To start formatting, select your KPI visual and click the paintbrush icon ("Format your visual") in the Visualizations pane.

Key Formatting Options to Review:

• Callout value: Here you can change the font size, color, and display units of your main number. For large numbers, changing the display units to "Thousands," "Millions," or "Billions" keeps your dashboard clean.
• Trend axis: You have the option to turn off the trend axis if you don’t need it. You can also change the transparency and color. A good practice is to make its color a bit muted, so it provides context without stealing the show.
• Target: This section lets you control how the target labels appear. You can decide whether to show the difference to the goal as a percentage, an absolute value, or both.
• Coloring: Under "Colors -> "Sentiment Colors," you can define the rules for your colors. This is the most powerful formatting option. By default, Power BI assumes that a higher value is better. But what if you're tracking customer churn or ad spend? In those cases, a lower number is better. You can easily switch the direction here from 'High is good' to 'Low is good' to ensure your color signals are accurate.

Common Troubleshooting Tips

Running into trouble? Most issues with the KPI visual are quick fixes.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

"My Trend Axis Chart isn't showing up or looks wrong."

This is almost always a data type issue. Double-check that the field you placed in the Trend axis is formatted as a Date or Date/Time type. You can check and change this in the 'Data view' within Power BI Desktop.

"The Green/Red coloring is backward!"

This happens when Power BI's default assumption doesn't match your goal. If you're tracking something like 'Response Time' where a lower number is better, you need to tell Power BI. Go to Format visual -> Colors and change the direction from "High is good" to "Low is good."

"I don't have a column for my target in my data."

No problem. If your target is a fixed number (e.g., $5,000 in sales per week), you can create a simple measure using DAX (Data Analysis Expressions).

1. In the Home tab, click "New measure."
2. A formula bar will appear. Enter a clear and simple formula, like:

Weekly Sales Target = 5000

1. Press Enter. This new measure will appear in your Fields pane, and you can now drag it directly into the "Target goals" box.

Final Thoughts

Mastering the KPI visual is a fundamental step in building Power BI reports that deliver genuine business value. By combining an actual value, a target, and a trend line, it gives stakeholders an instant and complete picture of performance without needing to dig through tables or filter complex charts. Now you know not only where to find it but how to set it up for maximum impact.

While manually building reports in Power BI is a powerful skill, sometimes you just need answers quickly without getting bogged down in field lists and formatting panes. This is why we created Graphed. After easily connecting your data sources, you can simply ask in plain language, "Show me our monthly revenue vs our target goal as a KPI," and get an interactive, real-time visual in seconds. It allows anyone on your team to create and track a business health dashboard, empowering them with instant insights.