How to Change Y Axis to Percentage in Power BI

Showing raw numbers on a chart is fine, but converting them to percentages often tells a much clearer story. A percentage gives you immediate context and proportion, which is exactly what a good report should do. This guide will walk you through the practical, step-by-step methods to change the Y-axis in your Power BI visuals to display percentages.

Graphed

Your AI Data Analyst to Create Live Dashboards

Connect your data sources and let AI build beautiful, real-time dashboards for you in seconds.

Build Your First Dashboard

Why Format Your Y-Axis as a Percentage?

Before diving into the "how," it’s useful to understand the "why." When you compare values, especially across categories with different scales, raw numbers can be misleading. Imagine you're comparing the conversion rate of two different landing pages. Page A had 50 conversions from 1,000 visitors, and Page B had 100 conversions from 5,000 visitors.

On a bar chart showing raw conversion counts, Page B looks twice as successful. But is it really? By converting these to percentages, the picture changes:

• Page A Conversion Rate: (50 / 1000) = 5%
• Page B Conversion Rate: (100 / 5000) = 2%

Displaying these percentages on your Y-axis immediately reveals that Page A is the high-performer. Using percentages standardizes your data, making comparisons fair, intuitive, and much easier for your audience to digest.

AI for Data Analysis

Crash Course

Graphed

Free PDF Guide

AI for Data Analysis Crash Course

Learn how to get AI to do data analysis for you — the best tools, prompts, and workflows to go from raw data to insights without writing a single line of code.

Download Free Guide

Method 1: The Quickest Way (Changing the Measure's Format)

The most direct way to show percentages is to change the format of the data field (known as a measure or column) that you're using. This method is perfect when your underlying data is already in a decimal format representing a proportion (e.g., 0.25 for 25%).

Let's say you have a measure called ConversionRate that calculates a value like 0.05. Here’s how to format it correctly:

1. Select the Measure: In the Data pane on the right side of your Power BI window, find and click on the measure you've placed on your Y-axis. In this case, it's ConversionRate.
2. Open the Measure Tools: When you select the measure, a new contextual tab called Measure Tools will appear in the top ribbon.
3. Change the Format: Look for the Formatting section in the ribbon. You’ll see a dropdown menu that might say "General" or "Decimal number." Click this dropdown and select Percentage.

That's it! Power BI automatically multiplies your decimal value (0.05) by 100 and adds a percentage sign, displaying it as "5%". Any visual using this ConversionRate measure will now show a percentage-formatted Y-axis.

Important Note: If your data is a whole number (like 5 for 5%) and you apply this formatting, Power BI will incorrectly display it as 500%. If that's your situation, the next method is for you.

Method 2: Using a DAX Measure to Calculate the Percentage

More often than not, you won't have a ready-made percentage field. Instead, you'll have two fields you need to compare, such as Sales for a specific category and Total Sales for all categories. This is where Data Analysis Expressions (DAX) comes in. Don't worry, the formula is straightforward.

Let's create a measure that calculates the percentage of sales for a specific product category relative to the grand total of all sales.

Step 1: Create the DAX Measure

First, we need to create a new measure that performs the division.

• In the Data pane, right-click on the table where you want to store your measure (e.g., the 'Sales' table) and choose New measure.
• The formula bar will appear at the top. Here, we'll write our DAX formula. We will use the DIVIDE function, which is a safe way to handle division and automatically manages scenarios where the denominator might be zero (avoiding errors).
• The formula will also use CALCULATE and ALL to ensure we are always dividing by the grand total, regardless of any filters applied within the visual itself.

Enter the following formula into the formula bar:

Percentage of Total Sales = 
DIVIDE(
    SUM('Sales'[Revenue]),
    CALCULATE(
        SUM('Sales'[Revenue]),
        ALL('Sales')
    )
)

Here’s a breakdown of what this does:

• SUM('Sales'[Revenue]): This is our numerator. It calculates the sum of revenue for the current context (for instance, a specific product category on our X-axis).
• CALCULATE(SUM('Sales'[Revenue]), ALL('Sales')): This is our denominator. The ALL('Sales') function tells Power BI to remove all filters from the 'Sales' table for this part of the calculation, giving us the grand total of revenue across all categories.

Step 2: Format the New Measure

Now that you have your measure, it will return a decimal value. You just need to format it as a percentage by following the exact same steps in Method 1:

1. Select your new Percentage of Total Sales measure in the Data pane.
2. From the Measure Tools ribbon, change the format from "General" to Percentage.
3. Drag your newly formatted Percentage of Total Sales measure onto the Y-axis field of your chart. Your Y-axis will now correctly show the percentage values.

Graphed

Your AI Data Analyst to Create Live Dashboards

Connect your data sources and let AI build beautiful, real-time dashboards for you in seconds.

Build Your First Dashboard

Method 3: Use a 100% Stacked Chart Visualization

Sometimes your goal isn't just to see a single percentage, but to view the relative proportion of multiple parts that make up a whole. For instance, how did different marketing channels contribute to total leads each month? The 100% Stacked Chart is built specifically for this purpose and handles all the percentage calculations for you.

1. Start with a regular chart: Create a standard Stacked column chart or Stacked bar chart. For our example, put 'Month' on the X-axis, 'Channel' in the Legend, and 'Lead Count' on the Y-axis. You'll see the raw number of leads for each channel, stacked on top of each other.
2. Switch the chart type: With the visual selected, go to the Visualizations pane. Instead of the "Stacked column chart" you selected, simply click on the icon for the "100% stacked column chart."

Instantly, Power BI recalculates everything. Your Y-axis will change to a scale from 0% to 100%, and each column will now fill the entire height of the chart. The colored segments within each column represent the percentage contribution of that channel for that month. No DAX required!

Troubleshooting Common Issues

Why is my chart showing 2,500% instead of 25%?

This is the most common hiccup people encounter. It happens when your source data is a whole number (like 25) instead of a decimal (0.25). When Power BI formats it as a percentage, it multiplies by 100, resulting in 2500%.

The Fix: You need to divide your number by 100 before formatting. The easiest way is with a simple DAX measure:

Corrected Percentage Measure = DIVIDE([Your Original Measure], 100)

Then, select this new measure and format it as a percentage. It will now display correctly.

The Y-axis shows a decimal but not the percent sign (%).

If you see values like "0.25" on your axis, it's a simple formatting issue. Your calculation is correct, but Power BI doesn't know you want to display it as a percentage.

The Fix: Locate the measure in your Data pane, select it, go to the Measure Tools in the ribbon, and explicitly set the format to Percentage.

AI for Data Analysis

Crash Course

Graphed

Free PDF Guide

AI for Data Analysis Crash Course

Learn how to get AI to do data analysis for you — the best tools, prompts, and workflows to go from raw data to insights without writing a single line of code.

Download Free Guide

My percentage values don't add up to 100%.

This usually occurs when you use a DAX measure like the one in Method 2 in a context where you don't want it to reflect the grand total. For example, the ALL() function ignores all filters. If you have a slicer for "Year," ALL() will show the percentage of the all-time total, which might not be what you want.

The Fix: Experiment with different DAX functions. If you want the percentage to respect page slicers but ignore filters within the visual, replace ALL() with ALLSELECTED(). Understanding evaluation context in DAX is a bigger topic, but this is a great starting point for resolving such issues.

Final Thoughts

Changing your Y-axis to display percentages in Power BI is a fundamental technique for creating insightful and easily understandable reports. Whether you use the direct formatting option, create a powerful DAX measure calculation, or switch to a 100% stacked chart, the flexibility is there to present your data with the right context.

We know that getting your reports just right - from learning DAX to wrestling with formatting options - can sometimes take hours out of your week. At Graphed , we created a tool to automate this entire process. You simply connect your data sources like Google Analytics, Shopify, or Salesforce, and then create entire dashboards just by describing what you want to see. Instead of writing DAX, you can just ask, "Show me a chart of sales revenue as a percentage of total," and get a live, interactive visualization in seconds, freeing you up to act on your insights instead of just building reports.