clustered bar chart color coding

[Anonymous]

Hello All,

I have a clustered bar chart and having different values

Sales1, Sales 2, Sales 3 .

Now I need to change the color for each bar based on thier value, But I see there is no custom color option for this chart.

Could any one suggest how to do this

[Anonymous · Accepted solution]

Hi @Anonymous ,

Please use the IF() or SWITCH() functions to create similar measure and use it as a conditional format for visuals.

Measure = 
VAR _total = SUM('Table'[Value])
VAR _colour =
SWITCH(
    TRUE(),
    _total>=5000 && _total<=6000,"Blue",
    _total<5000, "Red",
    _total>6000, "Green"
)
return
_colour

Attached PBIX file for reference.

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly -- How to provide sample data

[FarhanAhmed]

you can change the color  by going to the Format your Visual then go columns and create a expression for your data bar color