9 Replies Latest reply on Nov 25, 2015 12:48 AM by anneleen.deridder

    Conditional formatting measure values

    anneleen.deridder

      Hi,

       

      I've read a lot of topics on conditional formatting with 'measure values' but I still haven't found a solution for my problem.

      I have a table with 'measure names' in the rows and 'measure values' (4 average scores) as text. See the file attached.

      I want to add conditional formatting to this table (below 5 red, between 5 and 6 orange and above 6 green).

      It's not possible to use 'measure values' in a calculated field so I've added this calculated field to the color shelf:

      IF AVG([Scale01]) <5 then "red"

      ELSEIF AVG ([Scale01]) >=5 and AVG ([Scale01]) < 6 then "orange"

      ELSEIF AVG ([Scale01]) >= 6 then "green"

      else "" end

      The problem is that all the scores (of the four scales) now have the same color (the color of scale01), but I only want the color of Scale01 to change. The scores of the other 3 scales should have their own conditional formatting.

       

      Can someone please help me with this one?

      Thank you in advance!

       

      Kind regards,

      Anneleen