How to percentage and count in SSRS Pie Chart

Question

I have a Pie chart generated using SSRS. I would like to Show both Count and percentage in the Pie chart.

Right now, I am able yo show the count in pie charts as well as in the report.

I want to show the name of the partition and also the percentage directly pointed out.

Example :

ALD 38% 56

please help me withe properties to do it.

I'm using VS 2008

Answer 1

write down an expression on series label data like -

=Sum(Fields!DATA.Value, "Chart1_SeriesGroup1") & "("  
    &  Sum(Fields!DATA.Value, "Chart1_SeriesGroup1")  * 100 /Sum(Fields!DATA.Value, "DataSet1") 
    & "%)"

Here Chart1_SeriesGroup1 is the group name if you look at series group setting

Here DataSet1 is the name of Dataset

Here is the final output

Cheers :-)

Answer 2

1-right click on chart and select "show data label"

2-right click on label an select "series label properties"

3- general -> label data -> set this value = "#PERCENT (#VALY)"

4- it will be like this screenshot

Answer 3

In the label Properties type "#PERCENT" in Label Data

This can be used on its own or in conjunction with the other value itself by adding "#PERCENT(#VALY)"

Place this in quotes if you are trying to concat other values with it. For instance, this would show the label with the accompanying percent below

=First(Fields!Data.Value, "Chart_Group") & vbcrlf & "#PERCENT"

Where "Chart_Group" is the name of the grouped on field