Dimension Colours

[#1]

How do I define a colour for a specific dimension in a bar chart ?

eg In the pic below.... I want to define a colour for 'SLA Breached' and for 'Unknown', etc.....

The reason being, sometime 'Unknown' end up as being first in the list, then it takes up the first colour and so on.  Now I want it to keep it's colour no matter where in the list it falls.

[sushil353 · Accepted solution]

in expression click on + sign and then write condition like

pick(Match(Dimension,'SLA Breached','Unknown','Awaiting information','Danger'),color(1),color(2),color(3),Color(4))

you can define these color in color tab.

HTH

Sushil

[vishsaggi]

Hi Bradley,

Can you upload you sample app we can work on.

Thanks,
V.

[#4]

Hi Bradley,

I just tried Sushil Kumar's suggestion

Have a look at attached qvw.

[#5]

This is so COOL Sushil. 

Thanks man !!! It works.  Well done !!!!

Appreciate your help !!!!

[sushil353]

Cheers !!!

there is one shortcut for this:

color(Match(Dimension,'SLA Breached','Unknown','Awaiting information','Danger'))

[#7]

Great !  I'll give that a try as well !!