Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hi Power Bi community,
I wanted to remove totals and sub-totals for some columns in my matrix (Analysis columns, see below). I saw some posts on here, like ISFILTERED and HASONEVALUE, but it doesn't seem to work for me? Could you kindly direct me to the right solution?
Description | Period A Amount | Period B Amount | Period A Analysis | Period B Analysis |
+ Category 1 | 11 | 15 | AAA | CCC |
A | 5 | 7 | AAA | CCC |
B | 6 | 8 | BBB | DDD |
+ Category 2 | 15 | 19 | XXX | YYY |
C | 7 | 9 | XXX | YYY |
D | 8 | 10 | ZZZ | WWW |
Total | 26 | 34 | AAA | CCC |
Here are the measures for the columns:
Thank you!!
Solved! Go to Solution.
Hi @anmdf ,
As @aj1973 suggested, you can make some setting in Format pane to decide which field display the subtotal. Please refer the solution in the following thread to achieve it.
How to remove sub column total from matrix
1. Select the related visual
2. Navigate to Format pane and find Subtotals tab
3. Toggle the option "Per column level" on and turn off these analysis fields
Best Regards
Hi @anmdf
Turn off subtotals, Row and Column
Regards
Amine Jerbi
If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook
Hi @aj1973 ,
Thanks for the response. However, I don't have this option for column yet, my organization is still in the October 2020 version. As for turning of the row subtotal, it would turn off all the totals and subtotals, but I only want that for two of my columns (the analysis ones).
Hi @anmdf ,
As @aj1973 suggested, you can make some setting in Format pane to decide which field display the subtotal. Please refer the solution in the following thread to achieve it.
How to remove sub column total from matrix
1. Select the related visual
2. Navigate to Format pane and find Subtotals tab
3. Toggle the option "Per column level" on and turn off these analysis fields
Best Regards
What version are you currently using? Currently I'm not able to apply the solution to only one column (Oct 2020 version), it removes subtotal for the whole row. I only want to remove the ones in red below.
So far I did field formatting and made the subtotals white in font, but I was wondering if there was a cleaner way to do it.
Hi @anmdf ,
The version of my Power BI Desktop is 2.94.921.0 64-bit (June 2021), you can try to update your Power BI Desktop to this version. Later check whether it can resolve the subtotal problem after upgraded.
Best Regards