[ SSRS - Custom Pie Chart Legend ]

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})

Answer 1

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:

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.