Remove column subtotal from a matrix

[Florie]

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

[Anonymous · Accepted solution]

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.

[Florie]

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

[Anonymous]

Hi @Florie ,

Can look this snap,

Regrads,

Surya.

[Pow3Range]

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]

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]

@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.

[pankajnamekar25]

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]

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