Forum Discussion
Conditional Formatting for Entire Row in Matrix table
Hello, I am trying to get colour on entire row. I can colour only for specific value or column. But i need it for entire row. Requriement: Want to colour entire row based on number of empt...
Can't do it for each column. Sections(Column) will change based on slicer selection.
FIRSTNONBLANK() will also not work for measures.
Thanks!
For Measure, I shared the second option. Also when in a matrix you select both column and row, Then your formatting based on the measure should work.
Color scatter = if(SUM(Sales[Net Sales])>2500 && SUM(Sales[Margin])>400,"green","red")
Conditional formatting of matrix has been used