How to Use KPI Visual in Power BI

A great Power BI dashboard tells a clear story, and the KPI visual is one of your best storytellers. It doesn't just show a number, it immediately tells you if that number is good or bad and which direction it's trending. This article will walk you through what the KPI visual is, why you should be using it, and exactly how to set one up, step-by-step.

Graphed

Still Building Reports Manually?

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

Watch the Demo

So, What Exactly Is a KPI Visual?

First, let's break down the acronym. A KPI is a Key Performance Indicator. It’s a measurable value that shows how effectively you’re achieving a key business objective. For example, monthly recurring revenue, customer acquisition cost, or website conversion rate are all common KPIs.

The Power BI KPI visual is a specific chart type designed to display this information with maximum context in minimal space. It consists of three core components:

• Indicator: This is the main number - the current value of your KPI. It's the big, bold number that grabs your attention.
• Trend axis: This is the small area chart in the background. It shows you the history or performance of your KPI over a period of time, like the last 30 days or the past year.
• Target goal: This component compares your indicator to a predefined goal. It tells you not only your current value but also the distance to your target, shown as a percentage.

When combined, these three elements give you a powerful, at-a-glance snapshot. You don't just see a number like "$50,000 in sales", you see that it's +5% ahead of your $47,500 target and that the sales trend over the past quarter is upward.

Why Use the KPI Visual in Your Reports?

Dashboards can get crowded quickly. While you could create a card visual for the number, a line chart for the trend, and another card for the target, that eats up valuable screen real estate. The KPI visual elegantly combines all of this information into a single, compact block, offering several key advantages.

It Provides Instant Context

A number on its own often lacks meaning. Is 1,200 website sign-ups this month good? You don't know without more information. The KPI visual provides that context instantly. It compares the 1,200 sign-ups to your target (e.g., 1,000) and displays the background trend. The color-coding immediately signals performance - green for meeting or exceeding the goal, red for falling short. This turns raw data into actionable information without requiring the viewer to hunt through other charts for context.

Graphed

Still Building Reports Manually?

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

Watch the Demo

It Keeps Teams Focused on a Goal

When you place a KPI visual at the top of a marketing or sales dashboard, it constantly reinforces the team's primary objective. Is the goal to increase revenue? To reduce customer churn? To improve lead conversion rates? The KPI visual keeps that single most important metric front and center, tracking progress in real-time and motivating the team to stay on course.

It's Amazing for Quick Performance Checks

Executives and team leads rarely have time to analyze every detail of a report. They need to open a dashboard and understand the performance in seconds. A row of well-designed KPI visuals gives them that high-level overview immediately. They can see what’s on track, what’s trailing, and where they might need to focus their attention, all before scrolling down to the more detailed charts.

Your Step-by-Step Guide to Creating a KPI Visual

Ready to build one? Let's walk through the process of creating a KPI visual to track monthly sales revenue against a target.

Step 1: Get Your Data Ready

Like any Power BI visualization, the quality of your output depends entirely on the quality of your input data. To use the KPI visual, you'll need at least three things in your data model:

• An Indicator Value: This is the metric you want to track. In our example, this would be a column like Revenue or SalesAmount.
• A Time-Based Field: This is what Power BI will use for the trend axis. You'll need a column with dates, like OrderDate, CloseDate, or MonthYear. Make sure this column is set to a "Date" data type in Power BI.
• A Target Value: This is your goal. This could be a separate column in your table (e.g., SalesTarget) or a fixed measure you create yourself using DAX (Data Analysis Expressions).

Step 2: Add the KPI Visual to Your Report Canvas

This is the easy part. In the Power BI Desktop application, look at the Visualizations pane on the right-hand side. Find the icon that looks like a little scorecard with a trending line - this is the KPI visual. Click it to add a blank visual to your report canvas.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Step 3: Add Your Data to the Fields

With the blank KPI visual selected, you’ll see three main "wells" in the Visualizations pane waiting for your data. Here’s what to drag into each:

1. Indicator: Drag your primary metric field here. For our example, we would drag the Revenue column into this well. Power BI will likely default to summing this value, which is exactly what we want.
2. Trend axis: Drag your date field here. We’ll drag OrderDate into this well. This will create the background chart showing revenue over time.
3. Target: Drag your goal field here. Let's drag the SalesTarget field into this well.

As soon as you populate these fields, the KPI visual will come to life, displaying your current revenue, its relation to your target, and the sales trend over the timeline provided.

Customizing Your KPI Visual for Maximum Impact

The default KPI visual is pretty good, but you can make it even more effective with a few simple formatting adjustments. Select your visual and click the paintbrush icon ("Format your visual") in the Visualizations pane to open the formatting options.

Formatting the Key Elements

Here are a few of the most impactful settings to tweak:

• Callout value: This section controls the main indicator number. You can change the font, increase the text size to make it stand out, change its color, and adjust the display units (e.g., show $500K instead of $500,000).
• Trend axis: Don't like the color of the trend line? You can change it here. You can also adjust its transparency to make it more or less prominent against the background. If you prefer a cleaner look, you can even turn it off entirely.
• Target: This formatting option lets you control the label for your target goal. You can toggle it on or off, change its color, and adjust its formatting. This is also where you will find the crucial Distance formatting, allowing you to show the percentage difference to your goal.

Setting Up Color Coding

The real magic happens in the Color coding section. This is where you define the logic that turns your KPI red or green.

In this section, you'll see a Direction setting. This tells Power BI whether a high number is good or a low number is good.

• High is good: Select this for metrics like Revenue, Profit, or Sign-ups. The indicator will turn green when it exceeds the target.
• Low is good: Select this for metrics where you want the number to be as low as possible, like Expenses, Customer Churn Rate, or Support Ticket Response Time. The indicator will turn green when it's below the target.

From there, you can specify the colors you want to use for "Good" (when the goal is met or exceeded), "Bad" (when performance is below your goal), and "Neutral."

Common Challenges and Quick Fixes

Even a simple visual can run into a few hurdles. Here are a couple of common issues and how to solve them.

"My KPI doesn't show a trend line."

This almost always means there's an issue with the field you placed in the Trend axis well. Double-check that the column is formatted as a date type. Also, ensure you have multiple data points over that period. If all your sales are on a single day, there is no trend to display.

Graphed

Still Building Reports Manually?

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

Watch the Demo

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

No problem! If your goal is a fixed number, you can create a simple DAX measure. Go to the "Modeling" tab, click "New Measure," and enter a formula like this:

Monthly Sales Target = 150000

Now you have a new measure called "Monthly Sales Target" that you can drag into the Target well of your KPI visual. This is perfect for static, company-wide goals.

"The color is wrong for my metric."

This is almost always solved by confirming the Direction setting under Color coding in the format options. If your "Cost Per Lead" KPI is showing green when it's far above the target, it's likely because the direction is set to "High is good" when it should be "Low is good."

Final Thoughts

The Power BI KPI visual is a fundamental building block for any effective performance dashboard. It turns a simple number into a meaningful story by providing crucial context around trends and targets, all within a small, easily digestible format. Getting comfortable with its setup and formatting options is a quick way to make your reports not just informative, but instantly understandable.

While mastering Power BI is a great skill, sometimes the learning curve and manual setup for connecting data sources and building visuals can slow things down, especially for busy marketing and sales teams. We built Graphed to simplify this entire process. Instead of dragging and dropping fields and adjusting formatting, you can just ask questions in plain English like, "show me a KPI for our website conversion rate vs. our 4% target for the last 30 days." Our platform automatically connects to your live data sources and builds the dashboards for you, saving you from the manual work and letting you focus directly on the insights.