Change Bar chart Color as per measures

[ashishpalkar]

Hi There

I want to change color of Bars as per the measures.

Please find attached screenshot for your reference,

I am looking for something like this ,

Budget = Green

Forecast = Orange

Actuals = Red

Thanks for your help.

[Chanty4u]

attachment missing

[ashishpalkar]

Added

[Chanty4u]

did you tried colurs legend tab by measure?

[Chanty4u]

here is the best example i found for you check this migh help you

create a dummy dim with expresion use pick match

Custom color by expression for two different expressions

[ashishpalkar]

Yes, it doesn't mentioned which Color to use for specific measure.

[Chanty4u]

try this

if(measure=measure1,rgb(127,255,127),if(measure=measure2,rgb(255,127,127)))

[fabdulazeez]

I think you can add attach colors to master measure .

Than in colors & legend section of chart you can say use library colors measure

[ashishpalkar]

It shows bad field name for 'measure', we cannot define measure = measure1

[fabdulazeez · Accepted solution]