Forum Discussion
Power BI Desktop Matrix Total Formatting
H Anonymous
Yes, in your picture there are 2 levels of column subtotal.
You can manipulate wich of them to show with formating options .
For example :If I will need to show only the blue subtotal ( category level)
I will switch off the year subtotalThe pbix with the example is attached +
Take a look at the linked guide:
https://www.youtube.com/watch?v=UyJieY69_sEThe logic of rows subtotals is the same as that of the columns subtotals
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.
H Anonymous
Yes, in your picture there are 2 levels of column subtotal.
You can manipulate wich of them to show with formating options .
For example :
If I will need to show only the blue subtotal ( category level)
I will switch off the year subtotal
The pbix with the example is attached +
Take a look at the linked guide:
https://www.youtube.com/watch?v=UyJieY69_sE
The logic of rows subtotals is the same as that of the columns subtotals
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.
Thanks for your reply, Rita. Somehow it is working now. Appreciated!