cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Solution Sage

## I want to format cell of matrix where there is a value like shown in below image...

If there is a value in cell, format it shown below, irrespective of how small or big the value is.

Both are different columns at row and column level despite being same values.

1 ACCEPTED SOLUTION
Super User

@ddpl , You have to create a measure and use that conditional formatting

Example

Switch ( True(),

Max(Table[Row COl]) = Max(Table[Col COl]) , "Green",

(Max(Table[Row COl]) ="F" && Max(Table[Col COl]) = "G")  || (Max(Table[Row COl]) ="F" && Max(Table[Col COl]) = "G") , "Orange" ,

, "Red" //else

)

Learn Power BI Advance - PowerBI Abstract Thesis:
How to do conditional formatting by measure and apply it on pie?
https://community.powerbi.com/t5/Community-Blog/Power-BI-Conditional-formatting-the-Pie-Visual/ba-p/...
https://amitchandak.medium.com/power-bi-where-is-the-conditional-formatting-option-in-new-format-pan...

2 REPLIES 2
Super User

@ddpl , You have to create a measure and use that conditional formatting

Example

Switch ( True(),

Max(Table[Row COl]) = Max(Table[Col COl]) , "Green",

(Max(Table[Row COl]) ="F" && Max(Table[Col COl]) = "G")  || (Max(Table[Row COl]) ="F" && Max(Table[Col COl]) = "G") , "Orange" ,

, "Red" //else

)

Learn Power BI Advance - PowerBI Abstract Thesis:
How to do conditional formatting by measure and apply it on pie?
https://community.powerbi.com/t5/Community-Blog/Power-BI-Conditional-formatting-the-Pie-Visual/ba-p/...
https://amitchandak.medium.com/power-bi-where-is-the-conditional-formatting-option-in-new-format-pan...

Solution Sage

@amitchandak
What if I only want to highligh the RED ones ...?