Maximum value for y-axis goes to 1 and not 100 !!!
I have a percentage calculation within a table in SSRS 2005, which looks like this =Cint(Sum(Fields!performed.Value))/iif(Cint(Sum(Fields!opportunities.Value)) = 0, 1,Cint(Sum(Fields!opportunities.Value))) and the results appear as below... 100.00% 97.92% 100.00% 100.00% 100.00% 100.00% but i use the same query within a chart, the y-axis doesn't go to 100 but only to 1 is there anyway i could show that it goes to 100% i did try changing the maximum value within the chart option on the y-axis to 100 then the graph again will only go to 1
May 26th, 2011 5:52am

Hi, Right click on your chart and select 'Value Axis properties' . Go to 'Number' tab and change the format to 'Percentage'. Hope this helps.MSBI Developer
Free Windows Admin Tool Kit Click here and download it now
May 26th, 2011 7:54am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics