Tag Archives: ssrs pie percentages

SSRS Pie Charts – Displaying Percentages Instead of Values

Image

To display the series percentages rather than the values in a SSRS Pie Chart, follow these basic steps :

1. Right click on your your Chart’s Series Labels and select “Series Label Properties”.  If your Series Labels don’t exist yet you need to need to right click the Pie chart and select “Show Data Labels” then  you will be able to select “Series Labels Properties”.

2. In the General tab, under the Label Data field type “#PERCENT” which will default to 2 decimal places.  For no decimal places use “#PERCENT{P0}” or for 1 decimal place use “#PERCENT{P1}”.

3. If you do not yet have the UseValueAsLabel property of the Chart Series Labels set to False you will be prompted to do this when clicking OK.  Thats it, you’re done!

Reference … http://technet.microsoft.com/en-us/library/dd239373.aspx