Forum Discussion

tavolo89's avatar
tavolo89
Frequent Visitor
3 years ago

Conditional Formatting for Any Measure

I would like to create a single calculation which I can re-use to apply the same conditional formatting for any measure. For example:

 

SWITCH( TRUE(), SELECTEDMEASURE() >=0,"green", SELECTEDMEASURE() <0,"red", "yellow" )

I expect to then be able to reference this using the "field value" in the conditional formatting UI:

 

 

 

How can I do this? The above steps just colours all measure values green:

 

 

Using a calculation group I can dynamically change the text, but can't use it to colour the measure value accordingly. Regardless, I don't seem able to show my measure and the calculation group at the same time.

 

 

 

This does not seem to be as simple as I expected. The alternative is to apply a "rules based" conditional formatting to every measure, in every matrix which I would rather avoid.

 

Thanks for any help!

 

1 Reply

  • GG23's avatar
    GG23
    New Member

    Have you found a solution for this? I'm needing the same. Thanks