Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Quiny_Harl
Advocate III
Advocate III

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

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

Capture.PNG

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.

Capture2.PNG

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?

 

1 ACCEPTED SOLUTION
Anonymous
Not applicable

@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.

View solution in original post

3 REPLIES 3
Anonymous
Not applicable

@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
Super User
Super User

@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

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

@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.

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.