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.
