SSRS: Can you have the label of a (pie) chart be both the category AND the Percent

reporting-services charts report label pie-chart
ajspacemanspiff picture ajspacemanspiff · Oct 24, 2013 · Viewed 14.9k times · Source

I have a pie chart in SSRS. It contains many categories so it is kinda hard to read. What I would like to do is include the category AND the percent in the label, but I am not sure how to do this.

You can include the category by setting the label to [CategoryName] (this is the default). You can include the percent by changing that to #PERCENT. But I cannot seam to figure out how to include both.

Is there a VBA formula that I can add that will give me both?

Answer

Ian Preston picture Ian Preston · Oct 24, 2013

You can actually just shove #PERCENT into a larger string.

Some simple data:

enter image description here

And a simple chart based on this:

enter image description here

The expression used for the labels is:

=Fields!grp.Value & ": " & "#PERCENT{P2}"

Here {P2} is controlling the formatting. You should be able to adapt to your scenario.

Alternatively, for greater control you can just add the relevant % calculation in the label expression; in the above case this would be:

=Fields!grp.Value
    & ": "
    & Format(Sum(Fields!val.Value) / Sum(Fields!val.Value, "MyDataSet"), "P2")

Which in this case gives identical results to the above.

Related questions

SSRS chart does not show all labels on Horizontal axis

My SSRS report does not show all the labels on the horizontal axis. Please see below. Note how the red arrows point to the few that do show. So my question is, where are the rest of the labels? Each …

Read More
Implementing Target lines, in SSRS column Charts

I have a column graph, that shows a trend of consumption over time, The y-axis being consumption and x-axis being time in month, I have to implement a target consumption. I implemented a target, by adding data field with a …

Read More
Two chart types (bar and line) in same SSRS chart

How can SSRS 2005 represent two chart types (i.e., bar and line) on the same chart? I am trying to create a graph that looks like the professionally crafted image below: The chart would have one series represented as bar …

Read More