Forum Discussion
Need only grand total for Matrix Visual
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.
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.
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! 🤠Thanks Anonymous . Thanks a lot. it worked
7 Replies
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 .
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.
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.
Hi Ranjith_96
Go to Format Visual -> Visual -> Row subtotals and switch it off like in the image. It should do the work.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!
