How to Show Decimal as Percentage in Power BI

Seeing a list of raw decimals like 0.25, 0.58, and 0.09 on your Power BI report isn't very helpful when you're trying to communicate clear percentage-based insights. Displaying them as polished, easy-to-read percentages - 25%, 58.9%, and 9% - is a fundamental step in building user-friendly dashboards. This guide will walk you through the different ways to properly show a decimal as a percentage in Power BI, from the simple, one-click method to more advanced DAX-driven techniques.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Why Does Power BI Show Percentages as Decimals?

First, it's helpful to understand what's happening under the hood. Power BI, like most data tools, stores numerical values in their raw form. A percentage is simply a display format for a decimal number. Internally, the value is always a decimal (e.g., 0.75), which is what an engine needs to perform calculations like sums, averages, and subtractions. When you "format" it as a percentage, you're just putting a user-friendly mask on that number without changing its underlying value.

So, when you import a column of decimals that represent percentages like your session-to-lead conversion rate, Power BI will display them in their raw decimal form by default. Your job is to tell Power BI to apply the percentage display mask to that number everywhere it's used.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Method 1: The Easiest Way Using the Modeling Tab

This is the method you'll use 95% of the time. It’s quick, straightforward, and changes the formatting for your measure or column across the entire report file, ensuring consistency.

Here's how to do it in the Report View (the main canvas where you build visuals):

1. Select the Relevant Field: In the Data pane on the right side of your screen, click on the measure or column you want to format. For example, you might click on a measure named 'Click-Through Rate'.
2. Open the Tool Tab: When you select the field, a new contextual tab will appear in the main ribbon at the top of the window. If it’s a measure, you’ll see one called Measure tools. If it’s a column, you’ll see Column tools.
3. Apply Percentage Formatting: In the ‘Formatting’ section of that tab, you have two options:
4. Adjust Decimal Places (Optional): Right next to the format dropdown, you'll see a small box where you can type the number of decimal places you want to display. If you enter '1', a value of 0.1578 will be shown as 15.8%. If you enter '0', it would be 16%.

That's it! Every visual that uses that specific measure or column will now automatically display the value as a percentage. This ensures that your card visuals, bar charts, table matrices, and tooltips all show the same, consistent format.

Method 2: Formatting Directly in the Data View

You can also apply the same formatting from the Data View, which is useful when you're first examining your raw data. The steps are nearly identical and achieve the same report-wide result.

1. Navigate to the Data View by clicking the grid icon on the left-hand navigation pane.
2. From the Data pane on the right, select the table you are working with.
3. Click on the header of the column you want to format in the data table itself. This highlights the entire column.
4. The Column tools tab will appear in the ribbon at the top.
5. In the 'Formatting' section, click the % sign or select Percentage from the format dropdown menu. You can adjust the decimal places here as well.

Method 3: Using the DAX FORMAT Function (For Special Cases)

Sometimes, you need more granular control over formatting, especially when you want to combine a number with text in a custom label or dynamic title. This is where DAX’s FORMAT function comes in handy. It allows you to create a new measure that is pre-formatted as text.

Warning: The FORMAT function converts your number into a Text data type. This is crucial to remember because you can no longer perform mathematical operations (like SUM or AVERAGE) on its result. You also can’t use it on the axis of a chart. Think of this method as strictly for final, display-only outputs.

Let's say you have a measure called [Conversion Rate] that returns 0.045. Here’s how you could create a new formatted measure:

Conversion Rate Formatted = FORMAT([Conversion Rate], "0.0%")

Here’s what this does:

• FORMAT() takes the original numeric value from your measure, in this case, [Conversion Rate].
• The second part applies a format string, "0.0%". This tells DAX you want to see one decimal place and the percent sign.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Common Format Strings to Use with Percentages:

• "Percent": The default percentage format, usually with two decimal places.
• "0%": Formats as a percentage with no decimal places (0.045 becomes "5%").
• "0.00%": Formats as a percentage with two decimal places (0.045 becomes "4.50%").

You would use this formatted measure in a Card visual, a table for displaying final numbers, or to create a custom chart title - cases where further calculation isn’t needed.

Troubleshooting Common Percentage Formatting Issues

If you're still having trouble, you might be facing one of these common road bumps. Here's how to fix them.

Problem: My Percentage is 100x too high! (e.g., 0.25 shows as 2,500%)

This is an all-too-common data problem. You format 25 as a percentage, and it becomes 2,500%. Why? Because the percent formatting assumes the source number is a decimal (like 0.25). If your source data already provides the number as a whole integer (like 25), Power BI will multiply it by 100 when applying the percent format.

• The Fix: Create a new measure that divides the original by 100 before formatting. For example:

Actual Click Through Rate = SUM('MyTable'[CTR]) / 100

Then, apply the standard percentage formatting (Method 1) to this new measure. All your visuals should use this corrected measure instead of the old one.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Problem: The Percentage Formatting Button is Grayed Out

If you click on a column and discover you can't click the formatting options, it's almost always a data type issue. Power BI can only apply percentage formatting to numeric data types.

• The Fix: Confirm the data type of your column. You can do this in the Column tools tab. If the Data type is set to 'Text', you need to change it.
• Select the column, go to the Column tools tab and change the Data type to a number format like Decimal number or Fixed decimal number. Power BI will ask for confirmation. Once changed, the formatting options should become available.
• Note: If the change fails, you likely have non-numeric text values (like "N/A" or "None") in your column. You will need to clean these up first using the Power Query Editor.

Best Practices for Handling Percentages

To keep your Power BI reports clean and efficient, follow these simple rules:

1. Keep Calculations Numeric: Always perform your calculations using the raw decimal measures. Create a separate, explicitly formatted measure with FORMAT() only when you absolutely need a text-based result for display.
2. Format at the Source: Apply formatting to the base measure or column itself (using Method 1 or 2). This ensures that any time you drag that field into a new visual, it automatically has the correct format.
3. Check Your Incoming Data: Before you even start building, take a peek at your data in the Data View. Do your percentages come in as 0.5 or 50? Knowing this from the beginning will save you from major formatting headaches down the road.

Final Thoughts

Mastering how to turn a decimal into a percentage is a core skill for any Power BI user. For most cases, using the simple formatting options in the ribbon's Measure tools or Column tools is the fastest and most effective way to ensure consistency across your report. For those unique cases requiring customized text outputs, the DAX FORMAT function offers a powerful, albeit specialized, solution.

Building effective reports means telling a clear story, and proper number formatting is a huge part of that. We created Graphed because we believe the process of connecting data, asking questions, and getting clear answers should be simple for a non-expert. Instead of hunting through menus to get your formats right or writing DAX code, you can use our platform to just ask in plain language, "Show me a pie chart of sales by region as a percentage of total sales this quarter." Graphed instantly handles the data connections, crunches the calculations, and gives you back a real-time, shareable dashboard that communicates the exact insight you were looking for without you moving your finger.