Controlling subtotals in a Matrix

[michaeljc70]

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

[Skinned]

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

[Sean]

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

To improve the Matrix Vote for these 2 Ideas

Idea 1

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/9207006-matrix-collapse-expand-bu...

Idea 2

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/10948962-matrix-measures-or-value...

[Seth_C_Bauer]

@michaeljc70 I'm not aware of any column level controls, but you do have the ability to remove the subtotal row in formatting options.