Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
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. 🙂
Solved! Go to Solution.
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.
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!