how to remove column subtotals from matrix power bi

[viswaaa]

Hello All,

I have a matrix table where I have Year,Monthl in columns and Category in rows and showing the sales.
I am getting subtotals for monthly also, But I want show grand total for year only.

Please suggest how to do this

[Ritaf1983]

Hi @viswaaa 
To control column subtotals you need to switch on subtotals per column level :

and then switch off unwanted level :

the pbix is attached +

take a look at the linked video :
https://www.youtube.com/watch?v=UyJieY69_sE

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

[viswaaa]

Hi @Ritaf1983 ,

Actually I have 3 dimenisons in my columns like month,year and quarter.

In my case how can ignore sub totals for month and quarter

[Ritaf1983 · Accepted solution]

@viswaaa 
That's  ok it works in the same way 

I attached an updated pbix

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly