How to Show Target vs Achievement in Power BI

Tracking performance against goals is a fundamental part of running any business, from sales quotas to website traffic targets. In Power BI, you don't have to just show your numbers, you can visualize exactly how your actual results stack up against your planned targets. This article will walk you through several effective methods for creating target vs. achievement visuals, from simple charts to powerful key performance indicator (KPI) displays.

Graphed

Still Building Reports Manually?

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

Watch the Demo

First, Get Your Data in Order

Before you can build any visuals, you need to structure your data correctly. It's much simpler than it sounds. Your data source—whether it's an Excel spreadsheet, a SQL database, or a Google Sheet—should contain, at a minimum, three key columns:

• A dimension column (e.g., date, month, sales representative, product category).
• An achievement column (e.g., "Actual Sales," "Sessions," "Deals Closed").
• A target column (e.g., "Sales Target," "Session Goal," "Quota").

An ideal dataset would look something like this:

Once you've loaded this data into your Power BI report, you’re ready to start building calculations and visuals.

Create a "Variance" Measure with DAX

While you can often create charts using just your raw "Actual" and "Target" columns, the real analytical power comes from calculating the variance. Variance tells you the difference between what you planned and what you achieved. Creating this as a DAX (Data Analysis Expressions) measure makes it a reusable, dynamic field in your report.

Calculating the Variance Amount

This measure subtracts the target from the actuals to give you the raw difference. A positive number means you exceeded the target, and a negative number means you fell short.

In the "Home" or "Modeling" tab in Power BI, click "New Measure." Then, enter this formula:

Variance Amount = SUM('YourTableName'[Actual Sales]) - SUM('YourTableName'[Sales Target])

Make sure to replace 'YourTableName' with the actual name of your data table.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Calculating the Variance Percentage

The variance percentage gives you context. Being $5,000 under a $10,000 target is a huge miss, but being $5,000 under a $1,000,000 target is barely a blip. This measure shows how significant the variance is relative to the target.

Create another new measure with this formula:

Variance % = DIVIDE([Variance Amount], SUM('YourTableName'[Sales Target]), 0)

Using the DIVIDE function is best practice because it automatically handles any cases where the target might be zero, preventing errors in your report. After creating this measure, select it in the Fields pane and use the "Measure tools" ribbon to format it as a percentage.

Method 1: The Classic Combo Chart (Column + Line)

One of the most intuitive ways to show actuals vs. targets is with a combination chart. It's clean, easy for anyone to understand, and quick to set up.

When to use it: Great for tracking performance over time (e.g., monthly sales vs. monthly target).

How to Build It:

1. From the "Visualizations" pane, select the "Line and clustered column chart" icon.
2. Drag your date or category field (e.g., Month) to the "Shared axis."
3. Drag your achievement field (e.g., Actual Sales) to the "Column y-axis."
4. Drag your target field (e.g., Sales Target) to the "Line y-axis."

Instantly, you get a chart where the bars represent your actual performance, and the line shows the goal you were aiming for. It's immediately obvious which months you exceeded the target (bar is above the line) and which you missed (bar is below the line).

Method 2: The Gauge Chart for a Single KPI

A gauge chart is like a speedometer for your metrics. It’s perfect when you want to show performance for a single, overall business goal at a glance.

When to use it: Best for high-level dashboard metrics like "This Quarter's Revenue vs. Goal" or "Today's Website Visits vs. Target." Avoid using it for detailed comparison across many categories, as it takes up a lot of space.

Graphed

Still Building Reports Manually?

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

Watch the Demo

How to Build It:

1. Select the "Gauge" visual from the "Visualizations" pane.
2. Drag your Actual Sales measure to the "Value" field.
3. Drag your Sales Target measure to the "Target value" field.

The gauge will display your actual value with a needle or fill, and a small line will indicate the target. It's a quick, punchy way to tell if you're on track.

Method 3: The Bullet Chart for Detailed Comparisons

The bullet chart is one of the most effective and space-efficient visuals for comparing actuals against targets. Think of it as a supercharged bar chart that packs more context into a smaller space.

When to use it: Perfect for comparing performance across multiple categories in a single visual, such as sales performance by team member or marketing campaign ROI vs. goal.

How to Build It:

Power BI doesn't have a default bullet chart in the main visualization pane, but you can get one from the AppSource marketplace for free.

1. In the "Visualizations" pane, click the three dots (...) and select "Get more visuals."
2. Search for "Bullet Chart" (a popular one is made by OKViz) and click "Add."
3. With the freshly added Bullet Chart visual selected, configure the fields:

The bullet chart will display a bar for each category showing the actual value, with a vertical line marking the target. It makes comparing performance across multiple items incredibly simple.

Method 4: The KPI Card for a Status-Driven View

If the most important question is "Are we winning or losing?" then the native KPI card is your best bet. It not only shows the actual number but also the variance and a color-coded status.

When to use it: Excellent for top-level dashboard metrics where the trend and status (green/good or red/bad) are as important as the number itself.

Graphed

Still Building Reports Manually?

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

Watch the Demo

How to Build It:

1. Select the "KPI" visual from the "Visualizations" pane.
2. Drag your achievement measure (e.g., Actual Sales) into the "Indicator" field. This is the main number the card will display.
3. Drag your date field (e.g., Date) into the "Trend axis" field. This creates the small area chart in the background.
4. Drag your target measure (e.g., Sales Target) into the "Target" field.

The card will automatically calculate the difference between your indicator and target, show it as a percentage, and color it green when you're over target and red when you're under. You can customize these colors in the format settings to match your business logic.

Bonus Tip: Use Conditional Formatting on Any Chart

Don't stop at just building the charts—add a layer of at-a-glance insight with conditional formatting. For example, you can make the columns in your classic column chart change color based on whether you hit the target.

1. Create your "Line and clustered column chart" as described in Method 1.
2. Select the visual, and go to the "Format your visual" pane (the paintbrush icon).
3. Expand the "Columns" section and click the fx button next to "Color."
4. In the new window that appears:
5. Click "OK."

Now, your chart's columns will automatically turn green for months where you met or exceeded your target and red for months where you missed. This simple trick makes your report far more effective by letting your audience see performance patterns without even reading the numbers.

Final Thoughts

Visualizing your targets against actual performance in Power BI transforms a flat list of numbers into a clear story about goal attainment. By choosing the right visual for your specific need — whether it’s a combo chart, a gauge, or a KPI card — and enhancing it with DAX measures and formatting, you can create reports that drive meaningful business decisions.

While mastering DAX and navigating Power BI's settings can be incredibly powerful, sometimes you just need an answer fast without the setup. We built Graphed to cut through this complexity. You can securely connect your data sources (like Google Analytics, Salesforce, or Shopify) and simply describe the visualization you need in natural language. Ask, "Show me a bar chart of sales versus our monthly target for this year," and our AI instantly creates the interactive dashboard for you, keeping it updated in real-time so you can focus on insights, not setup.