Forum Discussion
Contitional format clustered column chart with multiple column values
jja create a measure for color
Create a profit variance measure and color measure
Color Measure =
IF ( [Profit variance] < 0, "Red", "Green" )
and now in conditional formatting of the bar, use field value and use above measure
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!
parry2k i cant find conditional formatiing. I guess amitchandak is right that there is no such possibility
- jja6 years agoHelper III
Hi parry2k
This is my example. Visual is line and clustered column chart. I want to make that red bar when it is <0 it is red else green or other color. Now i made it static red
- v-easonf-msft6 years agoCommunity Support
Hi , jja
After my test , it seems that if you only have one field in “column values”,you can open the Formatting pane by selecting the paint roller icon and then open the Data colors card to set Contitional format .
However,when more than one field is placed into "column values",you will find the options to set Contitional format for line and clustered column chart disappeared.
For you requirement, I'd like to suggest you contact to support team to investigate this issue .
Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.