color a bar chart based on measure NAME

[ziabobaz]

Hi,

I have a simple task although I can't figure out how to do it.

I have a bar chart with different measures and I want to color a bar based on the Measure used (NOT the value of the measure). So this is technically based on Measure name (easily done in Excel).

I could use the IF statement, but I don't understand how to refer to the Measure in the formula. Like if(measure = [Revenue], green(), blue()).

Is there a way to do it?

Thank you!

[shraddha_g · Accepted solution]

Use Valuelist() for dummy Dimension referring Measure

1st DImension : Dimension Field Name

2nd Dimension : Valuelist('Measure1','Measure2')

Expression:

pick(wildmatch(Valuelist('Measure1','Measure2'),'Measure1','Measure2'),

Expression for Measure1,

Expression for Measure2

)

Color by Expression:

pick(wildmatch(Valuelist('Measure1','Measure2'),'Measure1','Measure2'),

Color for Measure1,

Color for Measure2

)

[ziabobaz]

Brilliant

[ziabobaz]

the original bar chart has only one Dimension, so this won't work, right?

UPDATE: solved