Forum Discussion
Controlling subtotals in a Matrix
I don't know if I am missing something, but in a Matrix, is it possible to control what columns trigger subtotals? It seems that every non-measure column triggers subtotals and I have way more subtotals than I need or want.
Thanks
3 Replies
michaeljc70 Unfortunately this is not possible!
Look at my answer here http://community.powerbi.com/t5/Desktop/how-get-Grand-Total-on-Matrix-Visualization-without-the-row/td-p/28695/highlight/true/
To improve the Matrix Vote for these 2 Ideas
Idea 1
Idea 2
Well i dont know back then
But now is possible in the subtotal section of format.
You have to switch on the "Per row level" option and then it will appear the columns you want to subtotals.
Best regards
michaeljc70 I'm not aware of any column level controls, but you do have the ability to remove the subtotal row in formatting options.
