2 Replies Latest reply on Oct 26, 2014 9:11 AM by

    Conditional Color Formatting on Measure Values

    Azfar Shahid

      I have seen a number of discussions on the subject but no solution yet. This relates to not being able to use Measure Values in calculated fields to define a color coding logical statement.

       

      I have few measures such as Total Amount, %Labour and Count of Records. I want to color each column based on below and above average of each measure. e.g. if Average of Total Amount is $100 then anything below needs to be in red while above blue. But for % Labour if value is below 50% then it is red else blue etc.

       

      I do not want to reshape data and build a dimension column for each measure value. That is not an option. How can I achieve Color Coding in this case for each column?  Please help.