cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Regular Visitor

## Remove totals and sub-totals for some columns in a matrix

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:

Period A AmountCALCULATE([Amount], USERELATIONSHIP('Calendar - Period A'[Date], Database[Date]))
Period B AmountCALCULATE([Amount], USERELATIONSHIP('Calendar - Period B'[Date], Database[Date]))
Amount = SUM(Database[Value])
Period A Analysis = CALCULATE(MAX(Database[Analysis]), USERELATIONSHIP('Calendar - Period A'[Date],  Database[Date]))
Period B Analysis = CALCULATE(MAX(Database[Analysis]), USERELATIONSHIP('Calendar - Period B'[Date],  Database[Date]))

Thank you!!

1 ACCEPTED SOLUTION
Community Support

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

Community Support Team _ Rena
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
5 REPLIES 5
Community Champion

Hi @anmdf

Turn off subtotals, Row and Column

Regards
Amine Jerbi

and you can follow me on

Regular Visitor

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).

Community Support

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

Community Support Team _ Rena
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Regular Visitor

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.

Community Support

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

Community Support Team _ Rena
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.