Colours in Chart

[bimanbeginner]

Hi There

How do you keep the colours of a chart dynamic.

I want good to always be green average amber and bad red.

[pradosh_thakur]

Hi

pfa

add pick(match(Status,'Good','Average','Bad'),1,2,3) in the sort tab

regards

Pradosh

[bimanbeginner]

Hi Pradosh

In a case like the attached model when there is no data for the one month 201704 for average then it is not dynamic...

[pradosh_thakur]

presentation -> uncheck supress zero values

[pradosh_thakur · Accepted solution]

Try this instead

check the back ground color of the expression

regards

Pradosh

[bimanbeginner]

Thank you that works Perfect!!!