SSRS - Custom Pie Chart Legend

2
votes

I need some assistance with the following, I have a pie chart with 1 series(Area) and 1 value(Spend) Now my legend atm is just displaying my Area, but I wanted to add or custom my legend to display the Area and a percentage of the spend. e.g. Los Angeles - 34.5%

How and what should I do to achieve this and what am I doing wrong?

But using this in my custom legend:

#AXISLABEL (#PERCENT {P1})

Chart Properties

1
reporting-services

1 Answers

3
votes

If you're using multiple values and concatenating them together, you will need to use an expression, i.e =..., and use & to combine the different elements.

In your case this will be something like:

="#AXISLABEL" & " - " & "#PERCENT{P1}"

Edit after comment

The value displayed by #AXISLABEL will depend on what you've defined as the label value under the Category Group properties:

enter image description here

That said, if you're just looking to explicitly display the Area field, why not just change the expression to look at that directly instead of implicitly through the #AXISLABEL:

=Fields!Area.Value & " - " & "#PERCENT{P1}"

This seems like the easiest option based on what you describe.