How to Use KPI Chart in Power BI

Tracking your key performance indicators (KPIs) in Power BI is essential for understanding business health at a single glance. More than just a number on a card, the dedicated KPI visual tells a story of progress against a specific goal. This tutorial will walk you through exactly what the KPI visual is, how to build one step-by-step, and how to customize it to clearly communicate performance.

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 in Power BI?

Unlike a simple card or gauge, the Power BI KPI visual is specifically designed to evaluate the performance of a metric against a defined target. It efficiently packs a lot of context into a small space, giving you a quick understanding of whether you are on or off track. Every KPI visual is made up of three core components:

• Indicator: This is the main value, or the actual result, of the metric you are measuring for the current time period. For example, it could be this month's total sales.
• Target: This is the goal you are measuring against. It’s the benchmark that determines if the indicator's performance is good or bad. For example, it might be the sales quota for the month.
• Trend axis: This is a chart, typically an area or line chart, displayed in the background of the visual. It provides historical context, showing you the metric's performance over time and helping you spot patterns or trends leading up to the current value.

The visual combines these elements and uses color-coding - typically green for on-target and red for below-target - to deliver an instant verdict. It answers not just "What is our number?" but also "How does that number compare to our goal?" and "What’s the recent trend leading up to this?"

Graphed

Still Building Reports Manually?

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

Watch the Demo

When Should You Use a KPI Visual?

The KPI visual is perfect for high-level dashboard summaries where you need to communicate status quickly. It’s not meant for deep, granular data exploration, it's a progress report. It excels when you want to measure one value against its target.

Consider using a KPI visual for scenarios like:

• Sales Performance: Tracking "This Month's Revenue" (Indicator) against "Monthly Sales Quota" (Target), with daily sales shown in the trend axis.
• Marketing Campaigns: Measuring "Leads Generated This Week" (Indicator) versus "Weekly Lead Goal" (Target).
• Financial Dashboards: Comparing "Actual Gross Profit Margin" (Indicator) to "Forecasted Profit Margin" (Target).
• Website Analytics: Monitoring "Current Conversion Rate" (Indicator) against "Target Conversion Rate" (Target).
• Operational Efficiency: Displaying "Average Customer Wait Time" (Indicator) against a goal where a lower number is better, such as a "Target of 2 minutes or less" (Target).

How to Create a KPI Chart in Power BI: A Step-by-Step Guide

Building your first KPI visual is straightforward. Let's create a simple sales KPI that tracks monthly revenue against a target.

Step 1: Prepare Your Data

Before you build, check that your data model contains the necessary fields. For a KPI to work, you absolutely need:

1. A field containing the value you want to measure (the indicator). Example: A [Revenue] column in your sales table.
2. A field containing the goal or target. Example: A [RevenueTarget] column or a fixed measure.
3. A time-series field with consecutive values. Example: A [Date] column. This is crucial for the trend axis.

Your data might look something like this in a simplified table:

Step 2: Add the KPI Visual to Your Canvas

In Power BI Desktop, navigate to the Visualizations pane on the right. Find and click the icon that looks like a gauge with a checkmark – this is the KPI visual. An empty placeholder for the visual will appear on your report canvas.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Step 3: Configure the Data Fields

With the new KPI visual selected, you'll see three fields waiting for your data: Value, Trend axis, and Target. Simply drag your data fields from the Fields pane into the appropriate buckets.

• Into Value (some versions might call this 'Indicator'), drag your primary metric, like [Revenue].
• Into Trend axis, drag your date field, like [Date]. Power BI will automatically create a date hierarchy, you can leave it as is.
• Into Target, drag your goal field, like [RevenueTarget].

You should instantly see the KPI visual come to life, showing the latest period’s data. By default, it will show the most recent date period available in your dataset.

A Quick Note on Using Measures

While dragging columns works, using DAX (Data Analysis Expressions) measures is a best practice. Measures give you greater control over calculations. For instance, you could create explicit measures:

Total Revenue = SUM(Sales[Revenue])
Revenue Target = SUM(Sales[RevenueTarget])

Using measures makes your model more transparent, reusable, and powerful, especially when you need to apply more complex time-based logic later on.

Customizing Your KPI Visual for Greater Impact

The default KPI is good, but customizing it helps it align with your reporting standards and makes it easier to interpret. Select the visual, click the paintbrush icon ("Format your visual") in the Visualizations pane, and explore these options.

Tuning the Visual Elements

Under the "Visual" tab in the formatting pane, you can adjust the look of each component:

• Callout value: This is your Indicator. Change the font, size, and color to make it stand out. You can also adjust the "Display units" here from auto to thousands, millions, etc.
• Trend Axis: By default, this is on. You can toggle it off if you don't need the historical context. You can also change the transparency and color. Generally, a subtle gray works best so it doesn't distract from the main number.
• Target label: Here you can control the text for the Target. Often, the text "Goal:" followed by the value and the percentage difference is most insightful.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Mastering the Color Coding Logic

The real power of the KPI visual is its automatic color coding. You can control this logic under the “Colors“ dropdown. The most important setting here is Direction.

• High is good: This is the default. The visual will be green when the indicator value is higher than the target. This is perfect for metrics like revenue, leads, or conversion rate.
• Low is good: Select this for metrics where you want the number to be smaller than the target, such as expenses, customer complaints, or response time. The green/red logic will be inverted.

You can also customize the "Good color," "Bad color," and "Neutral color" to match your brand or dashboard theme.

Common Pitfalls and Best Practices

Avoid these common mistakes to make your KPI visuals as effective as possible.

• Missing a Target: The most common error is forgetting the target field. Without a goal, the KPI visual has no context and cannot tell you if the performance is good or bad. It's just a number.
• Incorrect Trend Axis: The trend axis field must be a time-based field (like a date). Using a non-chronological category like 'Product Name' will produce a messy and meaningless background chart.
• Overloading the Dashboard: KPI visuals are for high-level summaries. Don’t clutter a report with dozens of them. Choose a few truly "key" indicators for your main dashboard and move secondary metrics to other pages.
• Providing Context: Always give your visual a clear and descriptive title. Use filters and slicers on the page so users understand exactly what data a KPI is showing (e.g., "Q4 Revenue Goal for North America").
• Enable Drill-Through: For viewers who want to know why a particular KPI is red, set up a drill-through page. This allows users to right-click the KPI visual and jump to a detailed report that breaks down the numbers behind the high-level summary.

Final Thoughts

The Power BI KPI visual is one of the most effective tools for communicating progress in a dashboard. By combining an indicator value, a clear target, and a historical trend, it transforms a simple number into a meaningful story about performance that anyone can understand instantly.

Building high-quality dashboards in tools like Power BI is incredibly powerful, but getting all your data connected and formatted can be a constant, manual effort. This challenge is why we built Graphed. We connect directly to all your key platforms - from Google Analytics and Facebook Ads to Shopify and HubSpot - letting you create real-time dashboards and reports simply by describing what you need in plain English, a task that now takes seconds instead of hours.