How to remove one of values on Column subtotals on a PBI matrix report?

[xiaohongt]

Hi,

I have a matrix with rows, columns, and multiple values, on Column subtotals I need to remove one value, e.g. below screenshot, how can I remove "Selected Lengths" circled in red?

[xiaohongt · Accepted solution]

@amitchandak ,  do you know if there is any way to just remove "Selected Lengths" while keeping "_Diff", "%Diff" on Column subtotals for the example? thanks for your reply and your time

[v-angzheng-msft · Accepted solution]

Hi, @xiaohongt 

If you remove the subtotals, all the subtotals will not be displayed. Power bi cannot do this directly.
A workaround is to adjust the column width to 0 so that the column does not appear to exist.

Turn off Auto-size column width and word wrap settings for column headers.

Result:

Please refer to the attachment below for details. Hope this helps.

Best Regards,
Community Support Team _ Zeon Zheng

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

[xiaohongt]

Hi @v-angzheng-msft , thank you so much for your help and your reply! got it

[xiaohongt · Accepted solution]

@amitchandak ,  do you know if there is any way to just remove "Selected Lengths" while keeping "_Diff", "%Diff" on Column subtotals for the example? thanks for your reply and your time

[xiaohongt]

@amitchandak , in my e.g. the "Selected Lengths" is in Values, not in Columns, if I set the column on/off for Per Column level, it only makes all of the values ("_Diff", "%Diff", "Selected Lengths") on Column subtotals on/off.

What I need here is only to remove "Selected Lengths" on Column subtotals while keeping "_Diff", "%Diff" on Column subtotals, thanks for your reply and your time

[amitchandak]

@xiaohongt , You can only do it for columns/rows. There is Per under the total, Like Per Row/Column level, inside that choose the column and switch off subtotal