Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

Conditional Formatting of Bar Chart

I would like the bars that are below the target value to be red and those equal to or above target to be green.  I do not see the 'divergent' color bar options .. do I have an old version of the app?

 

 

 

 

 

 

 

 

 

 

Need Help

20 Replies

  • Vvelarde's avatar
    Vvelarde
    Community Champion
    9 years ago

    Anonymous

     

    Hi, The divergent option is show when you add a column or measure in Color Saturation.

    • Anonymous's avatar
      Anonymous
      Not applicable
      9 years ago

      Thank you ... I see it now.  Can you advise on how to dynamically change the color based on the target value?  If below 95 then red and if >=95 it should be green?

       

       

    • Anonymous's avatar
      Anonymous
      Not applicable
      9 years ago

      Thank you ... I see it now.  Can you advise on how to dynamically change the color based on the target value?  If below 95 then red and if >=95 it should be green?

       

       

       

       

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    I would like the bars that are below the target value to be red and those equal to or above target to be green.  I do not see the 'divergent' color bar options .. do I have an old version of the app?

     

     

     

     

     

     

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      9 years ago

      I would like the bars that are below the target value to be red and those equal to or above target to be green.  I do not see the 'divergent' color bar options .. do I have an old version of the app?

       

       

    • ThirdI's avatar
      ThirdI
      Advocate IV
      8 years ago

      hamzahad91

      Currently there is no way to format the column based on a variable value. Conditional formatting will only work for a hard coded value (Min/Max value).

      • djroller1's avatar
        djroller1
        Advocate I
        8 years ago

        You can conditional format a column based on a wide range of values   For example, if I set my min color to red and min value to -1, then any column that has a numerical value less than -1 will show up as red.    Conversely, if I set my max color to green and my max value to 1, any column that has a value >1 will have a color of green.    This is assuming I have my numerical column field  in both the value well and the color saturation well.