Forum Discussion

jja's avatar
jja
Helper III
6 years ago

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...
Need Help
parry2k's avatar
parry2k
Super User
6 years ago

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

jja's avatar
jja
Helper III
6 years ago

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's avatar
    v-easonf-msft
    Community Support
    6 years ago

    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.