How to color only Row subtotals

[sepehr485]

Hello.

I have a Matrix with monthly data and subtotals for both row and coloumn.however I want to color the row subtotals only. when I use the options in formatting and change the background color for subtotals, both row and columns would affected. Is there anyway to color  only rows?

Thanks

[ALLUREAN]

Hi, @sepehr485 

Is this a table or matrix?

In matrix you can set subtotal background for rows and columns separately.

[sepehr485]

Hello.

This is a Matrix. Can you show me where that option is? Because I couldnt find that in my panel. You can choose to have either row or column Subtotal or both. but I cant find to color them seperately. Thanks

[ALLUREAN · Accepted solution]

This is the latest version of Power BI Desktop (August) and if your version is pretty updated you can find it.

[sepehr485]

Thank you. I updated my PBI and found the features. The only thing is now it is highlighting differently than what you have done. As you see in the picture below, the cell that shows the total for the quarter remains white in the row that is all grey. Is there any way to fix that so that all the row is grey?  Thanks