Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I have a table that shows totals for each month and then a subtotal. Is there a way to just show the subtotal and not the indivudual months?
Solved! Go to Solution.
Hi @bbrowy,
Based on my research, there is no such a function to allow to show subtaotal row only. There is a option "Total Row" which we can turn on or turn off. However this option will control all the total row.
If you have any concern on this feature, you can submit your idea on the link below. If this feature was mentioned by mulitple users, product team will consider to add this feature to next release.
https://ideas.powerbi.com/forums/265200-power-bi-ideas
Regards,
Charlie Liao
@v-caliao-msftCan you please let me know how to add sub totals in a table view. I'm strglling to find it. Every other blog talks about matrix view when it comes to sub totals, but i'm sure there should be a way to add sub totals in a table.
Hi @bbrowy,
Based on my research, there is no such a function to allow to show subtaotal row only. There is a option "Total Row" which we can turn on or turn off. However this option will control all the total row.
If you have any concern on this feature, you can submit your idea on the link below. If this feature was mentioned by mulitple users, product team will consider to add this feature to next release.
https://ideas.powerbi.com/forums/265200-power-bi-ideas
Regards,
Charlie Liao
That answers my question, thank for the help.
I think you are talking about Matrix here, what are the columns you are using on rows and columns, can you share please?
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
120 | |
101 | |
71 | |
61 |