Multiple Colours for Chart Expressions

[JamGardner]

Hi All, 

I am building several different apps where I want to display various metrics that belong to different areas. These areas all have their own set of colour associated with them, a type of brand recognition. 

Normally if it was one measure I would just use an if statement, saying if Dept a use RGB(20,500,00) if Dept b use RGB(100,200,10) etc. 

However with charts with multiple measures I use custom colours with Hex codes in the chart i.e. ='#00504c,#54670,#11211'.

Is there any way to combine them both, so that if an end user selects dept A on a filter the metrics will adjust the colour code to that dept for easy recognition.

Thanks, I've not seen this before and I am fully expecting it to be a "nope" but thought I would ask in the hope. 

[brunobertels · Accepted solution]

Hi 

May be regarding this questions : 

Is there any way to combine them both, so that if an end user selects dept A on a filter the metrics will adjust the colour code to that dept for easy recognition.

somethink like that in color dode panel : 

If(getfieldselection(Dept)='A', colorcodefordeptA, if(getfieldselection(Dept)=B,colorcodefordeptB)) etc 

[JamGardner]

Amazing, Thanks!