How to Change Number to Percentage in Power BI

Displaying numbers as percentages is one of the most common tasks you'll perform in Power BI, turning raw data like 0.25 into a much more readable 25%. This simple formatting change makes your reports instantly easier for your audience to understand. This article covers several straightforward methods for changing numbers to percentages in Power BI, from a quick two-click format change to more powerful DAX calculations for advanced scenarios.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Method 1: Using the Ribbon to Format an Existing Field

This is by far the quickest and most common way to change a number into a percentage. It’s perfect when you already have a column or a measure in your data that represents a decimal value (like 0.75 for 75%) and you just want to change how it's displayed in your visuals.

This method applies the formatting directly to the data field itself, meaning any visual that uses this field will now display it as a percentage. This saves you from having to format it over and over again in different charts.

Here’s how to do it:

1. Select the Data Field: In the Data pane on the right side of the Power BI interface, find and click on the measure or column you want to format.
2. Access the Formatting Tools: Once you click the field, a contextual tab will appear in the top ribbon. If you've selected a column, it will be the Column tools tab. If it’s a measure, it will be the Measure tools tab.
3. Apply Percentage Formatting: In the "Formatting" section of the ribbon, you will see a large % button. Simply click this button.

That's it! Power BI automatically multiplies the underlying decimal number by 100 and adds a percentage sign. For example, a value of 0.1523 will instantly become 15.23%.

To control the number of decimal places, you can use the little box right next to the format type dropdown in the same "Formatting" section of the ribbon. You can increase or decrease the precision as needed.

When to Use This Method:

• You have a pre-existing column with decimal values (e.g., a tax rate of 0.08).
• You've already created a measure that calculates a ratio, but it's showing as a decimal.
• You want a quick and universal formatting change that applies everywhere the field is used.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Method 2: Creating a New Percentage Measure with DAX

Sometimes, you don't have a ready-made decimal field to format. Instead, you need to calculate a percentage based on two other numbers in your data. For instance, calculating a conversion rate requires dividing the number of conversions by the number of clicks. This is the perfect job for a DAX (Data Analysis Expressions) measure.

Creating a DAX measure gives you a reusable, dynamic calculation that respects the filters and context of your report. For example, your conversion rate measure will calculate correctly for a specific campaign, a date range, or for the entire dataset.

Example: Creating a 'Click-Through Rate' Measure

Let's say you have a table named 'Campaign Data' with two columns: "[Total Clicks]" and "[Total Impressions]". Here’s how you’d create a Click-Through Rate (CTR) measure:

1. In the Home tab of the ribbon, click New measure (Alternatively, right-click your data table in the Data pane and select "New measure").
2. An expression bar will appear at the top. Here, you'll enter your DAX formula.
3. Type the following formula:
4. Press Enter to save the measure. Your new measure, 'CTR', will appear in the Data pane with a small calculator icon next to it.

Why Use DIVIDE()?

You might be tempted to just use the slash operator like SUM([Total Clicks]) / SUM([Total Impressions]). However, the DIVIDE() function is safer. If your denominator (Impressions) is ever zero or blank for a certain filter context, using a slash will return an error (Infinity), which can break your visuals. DIVIDE() automatically handles these division-by-zero errors and returns a blank or an alternate value you specify, keeping your reports clean.

After creating the measure, you'll notice it still appears as a decimal (e.g., 0.045). Simply use Method 1 to format your new 'CTR' measure: select it in the Data pane, go to the Measure tools tab, and click the % button.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Example 2: Creating a 'Percent of Total' Measure

Another common scenario is calculating what percentage one category contributes to the total. For example, what percentage of total sales did a specific product generate?

Here's a DAX formula for that:

% of Total Sales = 
DIVIDE(
    SUM('Sales'[Sale Amount]),
    CALCULATE(
        SUM('Sales'[Sale Amount]),
        ALL('Sales')
    )
)

• SUM('Sales'[Sale Amount]) calculates the sales for the current context (e.g., for a single product in a table row).
• CALCULATE(..., ALL('Sales')) calculates the total sales amount across the entire sales table, ignoring any filters a visual might have applied.
• DIVIDE() then divides the product's sales by the grand total sales to get the percentage.

Again, once you create this measure, use Method 1 to format it as a percentage.

Method 3: Using Power Query for Permanent Transformation

What if your data isn't in a decimal format to begin with? Sometimes you might have a column where a percentage is stored as a whole number, like 55 for 55%.

If you use the regular formatting tools on the number 55, Power BI will turn it into 5500%, because it first multiplies the number by 100. In this case, you need to first divide the number by 100 before applying percentage formatting.

The best place to do this is in the Power Query Editor. This transforms the data at its source, so it's correct from the moment it enters your data model.

1. From the Home tab in Power BI, click Transform data to open the Power Query Editor.
2. Select the query (table) that contains the column you need to modify.
3. Select the column with the whole number percentages (e.g., a column named 'Discount Rate' with values like 10, 15, 20).
4. Go to the Transform tab in the Power Query ribbon.
5. Click the Standard button (it has a calculator icon) from the "Number Column" group.
6. From the dropdown menu, select Divide.
7. In the pop-up window, enter the number 100 and click OK.
8. Your column values will now be converted to their decimal equivalents (10 becomes 0.10, 15 becomes 0.15, etc.).
9. Click Close & Apply in the upper-left corner to save your changes and return to the main Power BI report view.

Now that the underlying data is in the correct decimal format, you can use Method 1 to apply the percentage formatting.

Method 4: Quick Measures for Easy Percent of Total Calculations

If you find writing DAX a bit intimidating, Power BI has a feature called "Quick measures" that provides a guided interface for creating common calculations like "percent of grand total." It writes the DAX for you behind the scenes.

Graphed

Still Building Reports Manually?

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

Watch the Demo

How to Use Quick Measures:

1. In the Data pane, right-click on the field you want to analyze (e.g., 'Sales Amount') and select New quick measure.
2. A "Quick measures" window will open.
3. Under the Calculation dropdown menu, find and select Percentage of grand total under the "Totals" category.
4. Drag your numeric field (e.g., 'Sales Amount') from the Data pane on the right into the Base value box.
5. You can add categories to the filter boxes if you want the percentage to be calculated over a specific dimension (e.g., drag 'Product Category' into one of the bottom boxes). For a simple percent of total, you can often leave these blank.
6. Click OK.

Power BI will automatically generate a new measure with the correct DAX formula. This measure might be named something like "Sale Amount % of grand total." Just like with a manually written DAX measure, you'll need to select this new measure and click the % button in the ribbon to properly format it.

Choosing the Right Method for Your Report

With several options available, which one should you choose?

• For simple display changes on existing values, Method 1 (Ribbon Formatting) is the fastest and easiest.
• When you need to calculate a new percentage value from two other numbers (like rates or ratios), Method 2 (DAX Measure) is the most powerful and flexible.
• If your source data stores percentages as whole numbers (e.g., 25 instead of 0.25), use Method 3 (Power Query) to fix the data first, then format it.
• If you're new to DAX and need a common calculation like percent of total, Method 4 (Quick Measures) is a fantastic, user-friendly starting point.

Final Thoughts

Mastering these different methods for showing percentages will make your Power BI reports cleaner and more professional. Whether it's a quick format change from the ribbon or a more robust DAX measure, converting numbers to percentages is a fundamental skill for effective data visualization.

Learning the ins and outs of formatting in tools like Power BI is incredibly valuable. At the same time, the whole process of connecting data sources, writing formulas, and configuring visuals can be a major time-sink. That's why we built Graphed, where we turn hours of manual analysis into seconds of conversation. Instead of clicking through menus or writing DAX formulas, you can simply ask, "show me the click-through rate by campaign for last month as a percentage" and get back an interactive, live-updating chart instantly. All the connecting, calculating, and formatting is handled for you.