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

ydaoud's avatar
ydaoud
Frequent Visitor
8 years ago

In power bi 2018

Matrix ==> Click on Format ==> subtotals ==> Row subtotals ON/OFF and/OR Column subtotals ON/OFF

 

Table ==> Format ==> Totals ==> ON/OFF

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    You are correct that you can remove totals for tables.  However you cannot remove a grand total for a matrix at this time.  

    • brycedwhite's avatar
      brycedwhite
      Frequent Visitor
      7 years ago

      I'm really quite surprised that we're not able to turn off grand totals on the matrix visual considering people have been requsting this enhancement for many years.  As a work-around I set the font and background color to white - not perfect, but it's OK for the time being.

       

      • solvisig's avatar
        solvisig
        Icon for Advocate III rankAdvocate III
        7 years ago

        brycedwhite

        Another workaround:
        If your columns in your matrix consists of measures, then you can do

        value = if(hasonefilter([highest level row column]);[valuecolumn]))

        this should make the grand total row blank. and no need to change the colors.