Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
tavolo89
Frequent Visitor

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:

 

tavolo89_0-1680699274815.png

 

 

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

 

tavolo89_1-1680699274816.png

 

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!

 

0 REPLIES 0

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.