How to Add a Percentage in Power BI

Updated on:

May 12, 2026

By:

Use this interactive demo to learn how to display percentage values in your Power BI visuals.

Quick summary

You can add percentage formatting in Power BI by navigating to Format visual settings and selecting the Percentage option under Data format. This method works directly on table or matrix visuals without requiring a DAX measure or calculated column.

Steps

Select the visual on your report canvas and open the Format visual pane.
Click General in the Format visual pane to expand the general formatting options.
Under General, click Data format to access the formatting controls.
Choose a column from the list to apply the percentage format settings to.
Under the Format options, click Percentage to apply percentage formatting to the selected column in Power BI.
Your visual now displays the percentage values successfully in Power BI.

📌 Why this matters

Displaying data as percentages in Power BI is essential for making reports more readable and actionable, especially when presenting growth rates, completion metrics, or share-of-total figures. Power BI's built-in Data format settings let analysts apply percentage formatting directly to table and matrix columns without writing any DAX formulas, saving time and reducing errors. This feature ensures that stakeholders see clean, context-rich visuals that communicate proportional data clearly. Mastering percentage formatting in Power BI helps business intelligence teams deliver professional, decision-ready dashboards faster.

Your product deserves an interactive demo

Start free

How to Uninstall Power BI

How to Compare Two Measures in Power BI

How to Compare Months in Power BI