Forum Discussion

KimStenager's avatar
KimStenager
New Member
10 years ago
Solved

Remove totals in matrix table

  How do I remove totals from the rows. When I make a matrix the columns delivers a total for every column, distubing the picture.
Need Help
  • Tsanka's avatar
    Tsanka
    10 years ago

    According to me marix properties->General->Row Totals on/off should work

Tsanka's avatar
Tsanka
Kudo Collector
10 years ago

According to me marix properties->General->Row Totals on/off should work

  • maracles's avatar
    maracles
    Resolver II
    10 years ago

    Tsanka I was aware of removing all row totals (a term which still seems the wrong way round to me - should be column totals!), however is there a way to remove sub-totals but keep table totals?


    • HansMostafavi's avatar
      HansMostafavi
      Advocate I
      10 years ago

      Total Column shows each row's total. Total Row shows each column's total. It's a bit odd, particularly if you compare with pivot table terminology. Does anyone know how to hide those annoying sub-total rows but to show only the Grand Total row?

      • unshou's avatar
        unshou
        New Member
        10 years ago

        I'd like to know how to remove subtotals - is this possible?

    • Tsanka's avatar
      Tsanka
      Kudo Collector
      10 years ago

      As far as I know - not. 

  • Avinash's avatar
    Avinash
    New Member
    10 years ago

    I am unable to find the properties for the Matrix, can you please show it visually.

     

    Thanks.

    • dlandry's avatar
      dlandry
      Helper I
      10 years ago

      Where did you find the matrix properties I can't find them in Power BI desktop

      • Anonymous's avatar
        Anonymous
        Not applicable
        9 years ago

        Click Visualizations, then Format icon (now looks like paint brush), then General.  You can turn off / on Total Row, Total Column.

    • Avinash's avatar
      Avinash
      New Member
      10 years ago

      Nevermind I got it :)

  • Bjoern's avatar
    Bjoern
    Continued Contributor
    10 years ago

    Yep, that should do the trick. You should consider getting the latest PBI version. It has not been enabled for long (4-6 weeks, I think).

    • afosse's avatar
      afosse
      New Member
      10 years ago

      Hi Bjoern,

      I have downloaded the latest version on 11/02/2016 and could not figure out how to remove totals in a matrix.

      Can you advise of the process?

       

      Thanks.

      • pritesho's avatar
        pritesho
        Helper I
        10 years ago

        Looks like the feature is disabled again.  I can not do it on Matrix either.

  • JohnThomas's avatar
    JohnThomas
    Helper II
    9 years ago

    So where's the Matrix Properties?!!!