Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to Solution.
This is the latest version of Power BI Desktop (August) and if your version is pretty updated you can find it.
Proud to be a Super User!
Hi, @sepehr485
Is this a table or matrix?
In matrix you can set subtotal background for rows and columns separately.
Proud to be a Super User!
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
This is the latest version of Power BI Desktop (August) and if your version is pretty updated you can find it.
Proud to be a Super User!
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
User | Count |
---|---|
107 | |
88 | |
81 | |
76 | |
71 |
User | Count |
---|---|
112 | |
104 | |
96 | |
74 | |
66 |