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

About AussieBICG

Connect with me here https://au.linkedin.com/in/aussiebicg

3 Responses

  1. Barb L

    i have been asked to display both the percentage AND the value for each series, like the following:
    70%
    n=200
    Can this be done, or are you only allowed 1 or the other?
    Thanks in advance. Barb

  2. Barb L

    Thanks for the response. In the meantime, after some experimentation, we decided it was “too crowded” to have all the numbers around the pie chart, so I added only the percentage to the end of the lines in the legend using =……. & ” (” & ROUND((SUM(Fields!TOTALCOUNT.Value) / SUM(Fields!TOTALCOUNT.Value, “DSetGraph2_DATA”)) * 100, 1) & “%)” — it worked, looks so much better, and everyone was “happy”.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s