Forum Discussion

AlexKamaev's avatar
AlexKamaev
New Member
9 years ago

Matrix subtotal

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...
AlexKamaev's avatar
AlexKamaev
New Member
9 years ago

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's avatar
Phil_Seamark
Microsoft Employee
9 years ago

Which matrix are you using?  

 

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

  • AlexKamaev's avatar
    AlexKamaev
    New Member
    9 years ago

    • v-ljerr-msft's avatar
      v-ljerr-msft
      Microsoft Employee
      9 years ago

      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. :smileyhappy:

       

      Regards