Display Percentage Values on a Pie Chart (Report Builder and SSRS)

 

Applies To: SQL Server 2016

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

report-builder-pie-chart-preview-percents

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

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

  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}".

  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.

Community Additions

ADD
Show: