Matrix subtotal

Question

Hello,i made very simple table - Region, Restaurant number, Restaurant adress and Revenue but when i add adress i see subtotals for every adress and it looks like double information. How i can hide subtotals for one dimension in Matrix?

phil_seamark · Answer

Hi&nbsp;AlexKamaev&nbsp;Could turning this off help?&nbsp;

alexkamaev · Answer

I don't know why but don't have "Total row" in Subtotal menu. My version of Power BI 2.46.4732.721 May 2017&nbsp;

phil_seamark · Answer

Which matrix are you using? &nbsp;&nbsp;I'm using the fancy new Preview matrix that you need to turn on in the settings.

alexkamaev · Answer

v-ljerr-msft · Answer

Hi&nbsp;AlexKamaev,
&nbsp;
Based on my test, the 'Total Row' option&nbsp; in Subtotal menu is for the new Matrix Preview visual, and this option&nbsp;is in General menu for the current Matrix visual. Setting it off will turn off all Totals(including sub total and Grand total), so it may be not the right solution here, and it seems no better solution currently.
&nbsp;

&nbsp;
Here is a similar idea about ablility to select sub totals for the matrix&nbsp;shared on Power BI Ideas. You can vote it up and add your comments there to improve Power BI on this feature.&nbsp;:smileyhappy:
&nbsp;
Regards

Forum Discussion

Matrix subtotal

5 Replies

Related content

Customize subtotal in matrix

Matrix subtotal

Subtotals in Matrix

Hide duplicative subtotals in matrix

Matrix visual subtotal