Forum Discussion

Trescher's avatar
Trescher
Frequent Visitor
8 months ago

Conditional formatting of measures

Hi,   I have multiple measures in my report and I want to make the font color change based on the value of the measure.    Let's say i have two measure; measure A and measure B, which are both pe...
Need Help
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
8 months ago

Instead of measures A and B use two measures "Value" and "Color" .  "Value"  will calculated the respective value (A or B) depending on where you are in the visual, and "Color" is an identical copy that provides a color name instead of the values, and can then be used for the conditional formatting.

 

This is a very common approach for all these vain "Make it look like Excel"  custom matrices.

  • Trescher's avatar
    Trescher
    Frequent Visitor
    8 months ago

    Thanks for the reply Ibendlin. This would result in double the amount of measures. So if i have 100 measures that need to follow a specific coloring rule, I also need to have 100 coloring measures?

     

    That seems inefficient to me.

    • lbendlin's avatar
      lbendlin
      Icon for Super User rankSuper User
      8 months ago

      no, you would end up with two measures. One for the value and one for the color.

      • Trescher's avatar
        Trescher
        Frequent Visitor
        8 months ago

         "Value"  will calculated the respective value (A or B)

        How would this work? I have a lot of measures of percentages (over 20!), I would need to use a switch measure to make this function?