Forum Discussion

Florie's avatar
Florie
Helper I
1 year ago
Solved

Remove column subtotal from a matrix

Hi. I'm trying to remove the column subtotals from this matrix: 

In format, when I turn off ' column subtotals', it also removes the grand total columns. Any ideas what to do? Many thanks :).

Need Help
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi Florie ,

           Column subtotals in format panel,You can enable per column level button and follow below steps

    1)select month in column level option which will be there in column subtotal and then disable the show subtotal

    2)Then select year in column level option and enable the show subtotal

     

    Regards,

    Surya.

8 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Hi Florie ,

           Column subtotals in format panel,You can enable per column level button and follow below steps

    1)select month in column level option which will be there in column subtotal and then disable the show subtotal

    2)Then select year in column level option and enable the show subtotal

     

    Regards,

    Surya.

    • Anonymous's avatar
      Anonymous
      Not applicable
      1 year ago

      Hi Florie ,

      Can look this snap,

      Regrads,

      Surya.

    • Florie's avatar
      Florie
      Helper I
      1 year ago

      Ah, I see! That worked. Thanks very much.

  • pankajnamekar25's avatar
    pankajnamekar25
    Super User
    1 year ago

    Hello ,

    Select the Matrix visual in your Power BI report.

    Go to the Format pane (click on the paint roller icon).

    Expand the Subtotals section.

    Toggle Column subtotals to Off.

    Thanks,
    Pankaj

    If this solution helps, please accept it and give a kudos, it would be greatly appreciated.

     

    • Florie's avatar
      Florie
      Helper I
      1 year ago

      Hi. Thanks for replying. I tried this already but it also removes the column totals (last 3 columns in my chart.)

  • Pow3Range's avatar
    Pow3Range
    Frequent Visitor
    1 year ago

    Total Visits Adjusted =
    IF(
    ISINSCOPE(Table[Month]), 
    SUM(Table[Visits]), 
    IF(
    ISINSCOPE(Table[Year]), 
    BLANK(), 
    SUM(Table[Visits]) 
    )
    )
    Florie If possible can you share PBIX With Dummy data 

    • Florie's avatar
      Florie
      Helper I
      1 year ago

      Thanks for replying. I'm not sure how to share the pbix with dummy data but thanks for offering to look. 
      Is the dax a measure?

      • Pow3Range's avatar
        Pow3Range
        Frequent Visitor
        1 year ago

        Florie  You have to decide the Scope in DAX which subtotals will be going to show and which not!
        You can share the PBIX File with Less data or make a same dummy data within powerbI so i will give the solution.