Matrix-conditional formatting

[mbelobaba]

Hi Community, 

I'm using matrix and want to apply conditional formatting on values of a row field. Can this be accomplished?

Thanks, 
Maja

[amitchandak]

@mbelobaba , You can not have it row. You have repeat it on all columns.

You have to do background color, font color, icon etc.

Scale, rule, and measures based(Field value).

You can create  measure and use that on all values

example

color =
switch ( true(),
FIRSTNONBLANK('Table'[commodity],"NA") ="commodity1" && sum('Table'[Value]) >500,"lightgreen",
FIRSTNONBLANK('Table'[commodity],"NA") ="commodity2" && sum('Table'[Value]) >1000,"lightgreen",
// Add more conditions
"red"
)

refer

Color Field - Color Measure - Conditional formatting
https://radacad.com/dax-and-conditional-formatting-better-together-find-the-biggest-and-smallest-num...
https://docs.microsoft.com/en-us/power-bi/desktop-conditional-table-formatting#color-by-color-values
https://exceleratorbi.com.au/conditional-formatting-using-icons-in-power-bi/
https://community.powerbi.com/t5/Desktop/FORMAT-icon-set-for-use-in-a-data-card/td-p/811692

https://exceleratorbi.com.au/dax-unichar-function-power-bi/

https://docs.microsoft.com/en-us/power-bi/desktop-conditional-table-formatting

[mbelobaba]

Hi @amitchandak, thanks for helping!

It's not an acceptable solution to repeat the values on all columns. They need to stay in rows.

[v-yiruan-msft]

Hi @mbelobaba ,

Currently Power BI don't support conditional formatting for entire row, you can try the method in this thread. Besides that, here is one similar topic shared on Power BI Ideas , you can vote it up and add your comments there to improve Power BI on this feature.

Best Regards

Rena