Combined Chart with 2 Expressions & Multicolor

[#1]

Hello!

I have the following combined chart with 2 expressions (expression 1 are the bars and expression 2 are the dots):

When I had only the first expression I had the option Multicolor activated and I could see a different color for every Zone.

Now I added the second expression and it just shows me the same blue color for all the Zones.

Is it possible to set a different color for every Zone?

Thank you!!!

[eduardo_sommer]

I think the onlu way is to set the backgroud color of the bar depending on the Zone. Something like

   If (Dimension = 'Zone 1', rgb(255, 0, 0),

       if (Dimension = 'Zone 2', rgb(0, 255, 0), rgn(0,0,255)))

Another possibility is to create an inline load, associating each zone, with 3 fields (red, green, blue) which will later be used in the color of the background of that dimension.

Eduardo

[Anonymous]

Check Background Color in Chart Expression Property. Use "If else condition" to fulfill your requirement.

Thanks