Need only grand total for Matrix Visual

[Ranjith_96]

Hi Power BI Community,

In the matrix visual below, i dont want the subtotals, i only need the grand total. Is it possible to acheive? Any suggesstions would be really helpful.

[Anonymous · Accepted solution]

Hi @Ranjith_96 

As the @Daniel29195 above said, His method is correct, maybe there are some problems with your operation process.

I created a table based on your screenshot.

Then follow the steps marked on my diagram to achieve your needs

Best Regards,

Jayleny

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

[Daniel29195 · Accepted solution]

@Ranjith_96 

go to row subtotals,

enable the per row level : 

choose from the dropdown , category , 

and turn off total

then choose service, and turn of subtotal .

let me know if this helps .

If my answer helped sort things out for you, i would appreciate a thumbs up 👍 and mark it as the solution ✅
It makes a difference and might help someone else too. Thanks for spreading the good vibes! 🤠

[mandyzamore]

Hi! This is a year later but hoping someone can help! What if you are giving users the ability to pick and choose what rows they want to see? How would you pick which row to keep subtotal? Hope this makes sense!

[katemarkoska]

Hi @Ranjith_96 
Go to Format Visual -> Visual -> Row subtotals and switch it off like in the image. It should do the work.

[Daniel29195]

@Ranjith_96 

in the matrix visualization pane, you can turn on/off the subtotals  base on the level you are on .

let me know if that works for you .

If this answers your question  ,  mark it as the solution ✅ so can you can help  other people in the community find it easily .
 

[Ranjith_96]

hI @Daniel29195 

Thanks much for your response. I tried that option but nothing is changing. I have give my pbix file link below, could you please check it.

ds.pbix

[Daniel29195 · Accepted solution]

@Ranjith_96 

go to row subtotals,

enable the per row level : 

choose from the dropdown , category , 

and turn off total

then choose service, and turn of subtotal .

let me know if this helps .

If my answer helped sort things out for you, i would appreciate a thumbs up 👍 and mark it as the solution ✅
It makes a difference and might help someone else too. Thanks for spreading the good vibes! 🤠

[Anonymous · Accepted solution]

Hi @Ranjith_96 

As the @Daniel29195 above said, His method is correct, maybe there are some problems with your operation process.

I created a table based on your screenshot.

Then follow the steps marked on my diagram to achieve your needs

Best Regards,

Jayleny

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

[Ranjith_96 · Accepted solution]

Thanks @Anonymous . Thanks a lot. it worked