Forum Discussion
Anonymous
4 years agoNot applicable
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 ...
- Anonymous4 years ago
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
FarhanAhmed
4 years agoCommunity Champion
you can change the color by going to the Format your Visual then go columns and create a expression for your data bar color