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

Learn from the best! Meet the four finalists headed to the FINALS of the Power BI Dataviz World Championships! Register now

Reply
Anonymous
Not applicable

Conditional Formatting based on calculated column

I am trying to highlight specific rows in a matrix.
I have created a column "Order" which assigns "1" to the items which should be hightlighted and "0" to the ones that should not be.
However, I can't use a column for conditional formatting, and I can't figure out a workaround for this issue.
My idea was to create a measure which basically returns identically to the column. I'm aware that to reference a column in a measure, you must wrap the column in an aggregation function like MIN, MAX, SUM, AVERAGE, etc.

But I can't find a function allowing me to return basically the same column. 

LCE_1-1633337913912.png

 

 

2 REPLIES 2
V-lianl-msft
Community Support
Community Support

I'm not sure about your expected results and your data model. Please let us know so that we can help you more accurately.

Based on my experience, columns can be used as conditional formatting in some scenarios.

PaulDBrown
Community Champion
Community Champion

To use the conditional column, create a measure as in
Cond Format Value = SUM(Table[Conditional column]) 
and use this measure in the conditional formatting interface. However it won't be dynamic.

 

Yo create an equivalent measure to return the same as the conditional column, can you please share some sample data?





Did I answer your question? Mark my post as a solution!
In doing so, you are also helping me. Thank you!

Proud to be a Super User!
Paul on Linkedin.






Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.

February Power BI Update Carousel

Power BI Monthly Update - February 2026

Check out the February 2026 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.