Contitional format clustered column chart with multiple column values

[jja]

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

[parry2k]

@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!

[jja]

@parry2k i cant find conditional formatiing. I guess @amitchandak is right that there is no such possibility

[parry2k]

@jja can you share what visual you are using and sample data.

[jja]

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-msft]

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.

[amitchandak]

@jja , As of now with multiple measures and when have legend conditional formatting is not supported