Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
Check out the May 2024 Power BI update to learn about new features.
User | Count |
---|---|
90 | |
79 | |
61 | |
60 | |
58 |
User | Count |
---|---|
151 | |
113 | |
99 | |
80 | |
72 |