Formatting Data Labels on a Pie Chart Contained in the Last Column of a Tablix

• Mad Hacker

  Default port

  Points: 1404

  More actions

  May 25, 2011 at 8:06 am

  #240178

  Hey folks,

  I've got a problem that is about to drive me crazy.

  I'm attempting to use a pie chart in the last column of a tablix in order to visually convey the values of the Percentage of Students having a GPA within predifiend ranges. I have the property for Show Data Labels turned on and I'm attempting to format the values of the data labels as Percent.

  The problem is that even though all of the of the labels contain the correct values, only the first one in the series is correctly formatted. So far I've been unable to figure out how to force the correct format on teh remaining labels in the series.

  Has anyone else had encountered this problem.

  Thanks in advance for any assistance.

• gsc_dba

  SSCertifiable

  Points: 5407

  More actions

  June 1, 2011 at 10:43 am

  #1332611

  I had a similar issue with a pie chart and found that doing it the old fashioned way:

  Add this to the data label

  =COUNT(Fields!YourField.Value) / COUNT(Fields!YourField.Value, "YourDataset")

  Add 0% to the format property or whatever your desired format is 0.00% for 2 decimal places...

  gsc_dba