Forum Discussion

Trescher's avatar
Trescher
Frequent Visitor
9 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
Trescher's avatar
Trescher
Frequent Visitor
9 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
9 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?