4 Replies Latest reply on Jan 2, 2019 11:04 AM by Ellen Yama

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

    Ellen Yama



      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,