Forum Discussion
jja
6 years agoHelper III
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 c...
parry2k
6 years agoSuper 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!
- jja6 years agoHelper III
parry2k i cant find conditional formatiing. I guess amitchandak is right that there is no such possibility