Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
Hello fellows! I need your help with subtotal/grand total in matrix:
I have this matrix and a total at the bottom. Is it possible to turn of subtotal for "price" part of matrix? I tried various things, but nothing fits me as perfectly as I need. If possible, help me to find approach.
Thank you!
Solved! Go to Solution.
Hi @genashpuryk
Unfortunetly no.
See if you have hierarchy in Row like Category> sub category > product
so you can disable sub row total but complety on product level or sub category not on specific product.
Similarly if you have hirrachy at column part of a matrix then again you can enable and disable the sub total of column but not part of it.
see if i remove subtotal then all the subtotal will remove not specific part of an account
I hope I answered your question!
Hi @genashpuryk
Unfortunetly no.
See if you have hierarchy in Row like Category> sub category > product
so you can disable sub row total but complety on product level or sub category not on specific product.
Similarly if you have hirrachy at column part of a matrix then again you can enable and disable the sub total of column but not part of it.
see if i remove subtotal then all the subtotal will remove not specific part of an account
I hope I answered your question!
Thank you! Have a nice day 😌
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
56 | |
55 | |
54 | |
37 | |
29 |
User | Count |
---|---|
77 | |
62 | |
45 | |
40 | |
40 |