Changing colors based on customer selection

[Steviem]

Hi All,

I have a data set of customers that shows if this customer is a (Average, Bad, Below average, Best, Good, immature and worst) in 4 different criteria. All the groupings (Average, Bad, Below average, Best, Good, immature and worst) have a color assigned to it. I want to create a dashboard to show the color for each criteria when the customer is selected without selecting the criteria to change the color. So if i select the customer it should show me that for Criteria 1 he is Best (Green), for criteria 2 he is Below average (Orange) etc. I am using a button to display the color with a if statement.

Thanks in advance

Regards

S

[anat · Accepted solution]

create master dimension then assign colors for each grade or use pick and match based on the selection like

pick(match(fieldname,'good','bad'),green(),red()))

[Steviem]

Thanks, will try and revert back.

[Rohan]

Hi Steve,

Whats your criteria ? is it based on some measure or will it be static based on some conditions ? 

If the criteria is static then what @anat suggested will do, Else you will have to use that measure expression with Aggr & create the master dimension. Hope this helps.

Regards,

Rohan.