Conditional Formatting in Matrix Rows in Power BI

Although Power BI allows for all table columns to be conditionally formatted, matrix rows eliminate this capability. This video demonstrates a handy workaround for adding indicators to matrix rows in power bi.

We are a Microsoft Gold Partner offering full service Microsoft Work Management consultancy, focused on Microsoft 365, Project, Teams, Power Platform, and SharePoint services and solutions. Whether you’re looking for a small tweak or complete overhaul, we have you covered. Our services are available a la carte so you get precisely what you need.

[priyankagarg_._]

Really great approach to deal with row column. Is there is any way to change background color instead of replacing with icon? Any help would be appreciated!

[JaisonMenezes]

Great workaround but it would be nice if you had provided links for those images

[naylord]

Thank you for this great explanation! Excuse me how you show the rows of the table grouped like that? I mean, without the plus sign and without the cascade for the details. Thanks in advance!

[nimishjain]

Can we add background color to a column placed in Row section of a matrix visual?

[suneelk]

Hi, I have employee table with standard targets and additional 4 sales tables and created consolidated report for the 4 tables and using total sales measure. How can I do conditional formatting whether employees reached the target or not?

[lexiteximexi]

And if I just want to change a fontcolour? Instead of adding an image? How I can then change the formatting? Is it even possible?

[andreasweizenegger]

This isn't true conditional formatting. This "workaround" wont enable you to color the text or background field of what ever is in the actual rows (left side) of a matrix