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

ronnoc's avatar
ronnoc
Advocate II
9 years ago

This is a really hopeless thread. Obviously a few people including myself with no idea how to disable the row totals.

 

"Just go to matrix properties" is extremely vague as this ribbon or drop down either doesnt exist on the current version or is very well hidden.

 

 

Tsanka's avatar
Tsanka
Kudo Collector
9 years ago

Hi ronnoc

 

Please take a look at the attached screenshot. Does it answer your question?

 

Best regards

Tsanka

 

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    Thanks!  I'm new to Power BI and could not find this.  Never thought to look under "General".  DOH!!  :-)

  • tcrip's avatar
    tcrip
    Regular Visitor
    9 years ago

    THANK YOU.  Not only is it not called "Properties" it was not where I expected it to be.

  • ronnoc's avatar
    ronnoc
    Advocate II
    9 years ago

    Yes it does cheers! Missed it all along. Thank you

    • codyj710's avatar
      codyj710
      Frequent Visitor
      9 years ago

      Hi all,

       

      Does anyone know if having sub-totalling as option at a field level is in the roadmap? 

       

      I.e. right now, you either have an all or nothing when it comes to totalling a matrix with multiple row fields, some of which we don't need totalling on.

       

      I don't think this is possibly currently?

       

      Thanks in advance,

      Cody

  • daftraft's avatar
    daftraft
    Regular Visitor
    9 years ago

    This is the correct answer and should be promoted to the top. Thanks Tsanka!