Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi There
How do you keep the colours of a chart dynamic.
I want good to always be green average amber and bad red.
Try this instead
check the back ground color of the expression
regards
Pradosh
Hi
pfa
add pick(match(Status,'Good','Average','Bad'),1,2,3) in the sort tab
regards
Pradosh
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...
presentation -> uncheck supress zero values
Try this instead
check the back ground color of the expression
regards
Pradosh
Thank you that works Perfect!!!