title | description | author | ms.author | ms.date | ms.service | ms.subservice | ms.topic | ms.custom |
---|---|---|---|---|---|---|---|---|
Display percentage values on pie chart in paginated report |
Learn how to display percentage values in a paginated report on a pie chart, in the legend or in the pie slices, in Report Builder. |
maggiesMSFT |
maggies |
06/18/2024 |
reporting-services |
report-design |
conceptual |
updatefrequency5 |
[!INCLUDEssrs-appliesto] [!INCLUDE ssrs-appliesto-ssrs-rb] [!INCLUDE ssrs-appliesto-pbi-rb] [!INCLUDE ssrb-applies-to-ssdt-yes]
In paginated reports, by default the legend shows categories. You might also want percentages in the legend or the pie slices themselves.
The Tutorial: Add a Pie Chart to Your Report (Report Builder) walks you through adding percentages to pie slices, if you'd like to practice with sample data.
-
Add a pie chart to your report. For more information, see Add a Chart to a Report (Report Builder and SSRS).
-
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.
-
On the design surface, right-click on the labels and select Series Label Properties. The Series Label Properties dialog box appears.
-
Type #PERCENT for the Label data option.
-
(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}".
-
On the design surface, right-click on the pie chart and select Series Properties. The Series Properties dialog box displays.
-
In Legend, type #PERCENT for the Custom legend text property.