This is probably an easy question but I cannot find a solution to this. The stored procedure that I use to retrieve data for my bar chart in SSRS returns an ordinal number for each row, which represents a group the item belongs to. For example, I get:
Car - 20% - 1
Bus - 10% - 1
Train - 15% - 1
Bike - 3% - 2
Inline skates - 16% - 2
so 1 is all vehicles with an engine, and 2 all vehicles without engine. What I would like to do is to plot a bar with the percentage for each row and in the color of the custom palette, so Car, Bus and Train would get the first color of the user defined
palette, Bike and Inline skates would be the second color of the custom palette.
I think I have to use the Choose function in the expression for this but I cannot figure out how to access the custom palette to retrieve all colors.
I know I could retrieve a color code from the database instead of the group ordinal, but I would prefer to have the color being picked from the custom palette; is this possible?
View Complete Post