How to change the background color for specific rows in a matrix?

[Quiny_Harl]

I want to change the background color for specific rows in a matrix based on the name of the row.

What I did so far was to create a conditional column X in the data table that says, for example, when asset_name is A82 give me 1, in all other cases give me 0. Then for each field in Values, I created a conditional rule based on that X column - when column X is 1 - blue color, when is 0 - white color.

Basically, I apply conditional background color for the columns. However, I want to be able to conditionally color the rows. There is no option to choose a background color for the fields in Rows. Therefore, I'm able to custom-color only the "column part" of the matrix. Is there any workaround for this?

[Anonymous · Accepted solution]

@Quiny_Harl 

Currently Power BI does not have such features to change the background color for the entire row, you may vote and check comments under this idea.

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/18159352-conditional-formatting-w...

However, you can also try this workaround solution:

https://community.powerbi.com/t5/Desktop/Background-color-for-a-row-table-matrix/td-p/714419

Paul Zheng _ Community Support Team
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Quiny_Harl , you have color all columns using the same rules.

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

[Quiny_Harl]

@amitchandak Thank you for your reply!

With this method you are able to custom-color only the columns, which I already did, but not the entire row of the matrix.