Matrix subtotal

[AlexKamaev]

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]

Hi @AlexKamaev

Could turning this off help?

[AlexKamaev]

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 

[Phil_Seamark]

Which matrix are you using?  

I'm using the fancy new Preview matrix that you need to turn on in the settings.

[AlexKamaev]

[v-ljerr-msft]

Hi @AlexKamaev,

Based on my test, the 'Total Row' option  in Subtotal menu is for the new Matrix Preview visual, and this option 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.

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

Regards