Forum Discussion
Florie
Helper I
Helper IRemove 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 :).
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.
pankajnamekar25
Super User
Super UserHello ,
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.
FlorieHi. Thanks for replying. I tried this already but it also removes the column totals (last 3 columns in my chart.)