Forum Discussion
Display Subtotals 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?
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-ideasRegards,
Charlie Liao
4 Replies
I think you are talking about Matrix here, what are the columns you are using on rows and columns, can you share please?
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-ideasRegards,
Charlie Liao
That answers my question, thank for the help.
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.
