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

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
flipacoin
Regular Visitor

Calculation item for conditional formatting

Hi!

I have a matrix with several measures and would like to do some conditional formatting. It is the same rule for each measure, so it seems obvious to use the SELECTEDMEASURE()-function.

I use tabular editor and make a calculation item

For example:
cf =
IF(SELECTEDMEASURE() > 0, "#F7F7F7", "#ABABAB")

After saving I get this "Name" column in my model, as expected, but for some reason I can't select it when using field value in the condition formatting pane. 

Does anyone have an idea?

Thank you!

1 REPLY 1
MFelix
Super User
Super User

Hi @flipacoin ,

 

The calculation groups are use to change the calculations you use on your report, and cannot be used directly on your condittional formatting.

 

Please check the usecase below:


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.