Forum Discussion
clustered bar chart color coding
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
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 _colourAttached PBIX file for reference.
Best Regards,
Gao
Community Support TeamIf 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
2 Replies
you can change the color by going to the Format your Visual then go columns and create a expression for your data bar color
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 _colourAttached PBIX file for reference.
Best Regards,
Gao
Community Support TeamIf 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
