I have a problem with Pie Charts in Reporting Services which i cant seem to find a solution for. My Pie chart is displaying the percentage of priorities for certain events for each month (See sample data below). As the priority bands are fixed (i.e an event
can either be priority 1, 2 or 3), what i would like to do is show each priority in the Legend of each pie chart, regardless of whether that month contains and data for that priority. I would also like to specify a colour for each priority so that the legend
for each months pie chart would show Priority 1 (Red), Priority 2 (Green) and Priority 3 (Blue).
Month - Priority 1 - Priority 2 - Priority 3
June - 5 - 2 - 3
July - 5 - 0 - 5
Aug - 0 - 10 - 0
Currently the legends for the above data would show:
June - Priority 1 (Red), Priority 2(Green), Priority 3(Blue)
July - Priority 1 (Red), Priority 3(Green)
August - Priority 2 (Red)
As mentioned above this omits the priorities which have a 0 value for that month, meaning when viewing the three rendered pie charts, the colours of each priority will potentially change.
I hope ive explained the situation well enough, and if anyone can offer a solution or point me in the right direction id be very apprechiative.
View Complete Post