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 conditional formating for that

I

6 Replies

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

  • 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's avatar
        parry2k
        Super User

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