Forum Discussion
Power BI Desktop Matrix Total Formatting
Hi, can someone help me with this total columns?
I would like to keep the green total but get rid of red total. but I can only did the following:
I know it is the same total, just trying to learn more to see if that wish could come true. 🙂
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.
2 Replies
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.