3 Replies Latest reply on Oct 2, 2018 8:30 AM by Wen Lin Kwek

    Conditional color format the measure value to change color based on Parameter Value

    Wen Lin Kwek

      Hi There,

       

      I am trying to create conditional formatting on the measure value such that when it is >= the target parameter value, it will be green color, else it will be red color.

       

      I created a format calculation based on that logic, however, when I drag it onto marks color pane, I see only one color option (either Red or Green) on the legend. Will appreciate if anyone is able to propose a solution such that the legend will show both colors (red and green), so that when the database updates the values, the colors will change accordingly.

       

      I have attached a sample workbook for your understanding.

       

      Parameter Issue.JPG

       

      Best Regards

      Wen Lin