4 Replies Latest reply on Feb 15, 2018 3:12 PM by Lance Martens

    How to Conditional Format Specific Measures / Labels?

    Lance Martens

      Hi All,

       

      I would appreciate any assistance with developing the calculated fields to enable me to Conditional Format Specific Measures / Labels in my workbook.

       

      Logic:

      I have three measures, namely

      1. Planned,
      2. Actual, and
      3. Variation

       

      Assistance required context:

      • The Planned measures Label should remain black in colour (e.g. 400)

       

      • If Actual is > Planned, then the Actual Label needs to turn green (e.g. 600)
      • And the Variation measure now being positive, the Variation Label needs to turn green (e.g. 200)

       

      • If Actual is < Planned, then the Actual Label needs to turn red (e.g. 300)
      • And the Variation measure now being negative, the Variation Label needs to turn red (e.g. - 100)

       

      PS!

      I have manually configured the dashboard in my workbook to provide further context regarding the result I’m after, (reference illustration as well?)

       

      CF.JPG

       

       

      I have attached my workbook (v10.4)

       

      Any guidance will be most appreciated, 
      Cheers,

      Lance