How to Show Percentage in Gauge Power BI

The gauge visual in Power BI is a fantastic way to track progress toward a goal, but showing a simple count isn't always the most intuitive way to represent that progress. Displaying your key performance indicator (KPI) as a percentage adds immediate, universal context that a raw number often lacks. This article will walk you through exactly how to create and format a gauge chart in Power BI to show a percentage, turning your data into a clear and compelling visual.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

What is a Gauge Visual and Why Use It?

Think of the gauge visual as a speedometer for your business metrics. It uses a radial arc or a circular scale to show a single value, measuring it against a defined target or range. It's an excellent choice for dashboards where you need to communicate the status of a specific KPI at a glance.

The core components of a Power BI gauge are:

• Value: The current measure you are tracking (e.g., actual sales, tasks completed).
• Minimum Value: The starting point or bottom of the range.
• Maximum Value: The endpoint or top of the range.
• Target Value: The specific goal you are trying to reach.

For example, if you have a monthly sales goal of $100,000, your minimum would be $0, your maximum would be $100,000, and your value would be the current sales total. The needle on the gauge would then instantly show how close you are to hitting your number. While this is useful, converting that value to a percentage - like "85% of target achieved" - makes the information even more powerful and easy to understand.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

The Advantage of Using Percentages

Numbers need context. If you say you've completed 257 tasks on a project, is that good or bad? The answer depends entirely on the total number of tasks. But if you say you’ve completed 85% of the tasks, everyone immediately understands where the project stands, regardless of its size.

Using a percentage in your gauge offers two main benefits:

1. Standardization: Percentages provide a common scale. You can compare the progress of a small project with 50 tasks to a large project with 5,000 tasks on a level playing field. Both can be measured on a simple 0% to 100% scale.
2. Instant Clarity: Your audience doesn't need to perform mental math to understand the status. A percentage is a universally understood measure of completeness or achievement.

Preparing Your Data for a Percentage Gauge

Before you can build your visual, you need to calculate the percentage you want to display. This isn't done in the gauge visual itself but by creating a new measure using DAX (Data Analysis Expressions), Power BI’s formula language. Don't worry, the formula is quite simple.

Let’s assume you have a simple dataset tracking project tasks, with columns for Project, Total Tasks, and Completed Tasks.

To show a percentage, you need to divide the number of completed tasks by the total number of tasks. You'll write a DAX measure to handle this calculation for you.

Step-by-Step Guide: Building Your Percentage Gauge

Follow these steps to go from raw data to a finished percentage gauge visual.

Step 1: Get Your Data into Power BI

First, load your data into Power BI Desktop. You can do this from the Home ribbon by clicking Get data and selecting your source, like an Excel workbook or a SQL database. Once loaded, you'll see your table available in the Data pane on the right side of the screen.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

Step 2: Create Your Percentage Measure with DAX

This is the most critical step. We will create a measure that performs the percentage calculation. A measure is a dynamic calculation that responds to filters in your report.

1. In the Data pane, right-click on your table and select New measure.
2. The formula bar will appear at the top. Here, you'll enter your DAX formula.
3. We will use the DIVIDE() function. This is a best practice because it gracefully handles cases where the denominator is zero (which would otherwise cause an error), returning a blank or a specified alternate result.

Type the following formula into the formula bar and press Enter:

Tasks Completed = DIVIDE( SUM('YourTableName'[Completed Tasks]), SUM('YourTableName'[Total Tasks]) )

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

Step 3: Format the Measure as a Percentage

Right after creating the measure, it will be formatted as a general number (e.g., 0.85). We need to tell Power BI to display it as a percentage.

1. With your new measure (Tasks Completed) selected in the Data pane, the Measure tools contextual tab will appear in the top ribbon.
2. In the "Formatting" section of this tab, click the percentage sign (%).
3. You can also adjust the number of decimal places here if needed.

Your measure is now ready to use!

Step 4: Add and Configure the Gauge Visual

Now for the fun part. Let's create the gauge.

1. Click on a blank space in your report canvas.
2. In the Visualizations pane, click on the Gauge icon.
3. An empty gauge visual will appear on your canvas. Drag the new Tasks Completed measure from your Data pane and drop it into the Value field in the Visualizations pane.

Instantly, the gauge will spring to life, showing your calculated percentage!

Customizing Your Gauge for Maximum Impact

A basic gauge is good, but a well-formatted gauge is great. A few tweaks can make your visual much clearer and more professional-looking.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

Setting the Minimum, Maximum, and Target Values

Since we are working with percentages, the range should be set accordingly.

1. Select your gauge visual.
2. In the Visualizations pane, stay on the "Fields" tab (the one you used to add the value).
3. Here, you will set the minimum and maximum inputs:
4. Target value: If you have a specific goal, like reaching 95% completion, you can enter 0.95 here. A small line will appear on your gauge indicating the target.

Enhancing The Visuals

Click on the Format your visual tab (the paintbrush icon) in the Visualizations pane to customize the look and feel.

• Gauge axis: Here you can change the colors of the arc. A common practice is to use conditional colors - for example, red for 0%-50%, yellow for 50%-80%, and green for 80%-100%. You can do this by setting rules using the Conditional formatting (fx) button next to the Fill color.
• Data labels: Adjust the color, size, and font of the percentage text shown in the center to make it more readable.
• Target label: Customize the appearance of the target value, if you are using one.
• General: Find options here to add a descriptive Title, adjust its font and alignment, and add effects like a border or shadow to help the visual stand out on your dashboard.

Common Mistakes to Avoid

When working with percentage gauges, a couple of common issues can trip you up. Here’s how to avoid them.

• Forgetting to use DIVIDE(): If there's a chance your 'Total Tasks' could be zero or blank, using a simple slash (/) for division will result in an error that breaks your visual. The DIVIDE() function prevents this.
• Setting the Maximum Value Incorrectly: Remember, when your measure is formatted as a percentage in the data model, Power BI understands it on a scale of 0 to 1. Always set your gauge's maximum value to 1. Setting it to 100 will cause the gauge to display incorrectly, as it would be trying to show 85% on a scale of 0 to 10,000%.
• Ignoring Filter Context: Like all Power BI visuals, your gauge is interactive. If you add a slicer for 'Project Name', the gauge will dynamically update to show the completion percentage for only the selected project. This is a feature, not a bug, but it's important to be aware of what filters might be affecting your visual.

Final Thoughts

By creating a simple DAX measure, you can easily transform Power BI's standard gauge into a clear and effective percentage meter. This small change provides far more context than a raw number, works across datasets of any size, and allows your stakeholders to understand performance at a single glance.

Setting up reports in tools like Power BI is incredibly powerful, but often requires learning details like DAX syntax and proper visual configuration. At Graphed , we’ve built a way to get these insights without the learning curve. You can connect your data sources in a few clicks and simply ask, "Show me our project completion rate percentage in a gauge chart this quarter." We instantly build a live dashboard for you, turning hours of manual setup into a quick conversation and getting you back to analyzing, not just building.