Edit

Share via

Display percentage values on pie charts in Power BI paginated report (Power BI Report Builder)

  • Article

APPLIES TO: Power BI Report Builder Power BI Desktop

In Power BI paginated reports, by default the legend shows categories. You may also want percentages in the legend or the pie slices themselves.

Screenshot of a pie-chart-other-slice, pie chart showing percentages for the slices of the pie.

The Tutorial: Add a Pie Chart to Your Report (Power BI Report Builder) walks you through adding percentages to pie slices, if you'd like to try this with sample data first.

Display percentage values as labels on a pie chart

  1. Add a pie chart to your report. For more information, see Add a Chart to a Report (Power BI Report Builder).

  2. On the design surface, right-click on the pie and select Show Data Labels. The data labels should appear within each slice on the pie chart.

  3. On the design surface, right-click on the labels and select Series Label Properties. The Series Label Properties dialog box appears.

  4. Type #PERCENT for the Label data option.

  5. (Optional) To specify how many decimal places the label shows, type "#PERCENT{Pn}" where n is the number of decimal places to display. For example, to display no decimal places, type "#PERCENT{P0}".

Display percentage values in the legend of a pie chart

  1. On the design surface, right-click on the pie chart and select Series Properties. The Series Properties dialog box displays.

  2. In Legend, type #PERCENT for the Custom legend text property.

Related content