Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Learn from the best! Meet the four finalists headed to the FINALS of the Power BI Dataviz World Championships! Register now
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.
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.
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?
Proud to be a Super User!
Paul on Linkedin.
Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.
Check out the February 2026 Power BI update to learn about new features.
| User | Count |
|---|---|
| 61 | |
| 59 | |
| 42 | |
| 18 | |
| 15 |
| User | Count |
|---|---|
| 109 | |
| 100 | |
| 39 | |
| 29 | |
| 29 |