2 Replies Latest reply on Nov 20, 2018 9:55 PM by Milan Das

    Color Code (conditional format like Excel) Measure Values in a Table based on Value

    Ellen Yama

      Hi,

       

      I am trying to format the text of a table based on the value of measure values. For example...I have 16 measure values each with their measure name. The values range from 0 to 100. If the value is 65 or less, I want it to be red text, if its 66 to 80, I want it to be gold text and its above 81, then I want it to be green. Can anyone help me do this? I have tried doing a calculation but it changes all numbers to the color coding of only one of the measure values. The same rule will apply to all measures but I want it to look at the value in each measure value and apply it rather than looking at one and applying that same color to the remaining values.

       

      Thank you,

      Ellen