Forum Discussion
Contitional format clustered column chart with multiple column values
Hi
How do i format a column with a color?
I have 2 columns: Profit and Profit variance(Profit-Budget)
i want to make if Profit variance<0 then the bar color ir red else green.
I dont see any conditional formating for that
I
6 Replies
- amitchandakSuper User
jja , As of now with multiple measures and when have legend conditional formatting is not supported
- parry2kSuper User
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!
- jjaHelper III
parry2k i cant find conditional formatiing. I guess amitchandak is right that there is no such possibility