Show selected row-subtotals in a pivot table

[Viksha]

Hi, 

I created a pivot table with rows subtotal. 

As a default, PowerBI includes asubtotal for all of the rows - meaning 4 subtotals, but I want to keep only the first 3,
meaning I want to remove the one in yellow - and trying to figure out how: 

the only solution that I found so far is turning the values in this subtotal to white and then it's not seen, but it still shows the header of the subtotal.

Would highly appreciate your help:)

[HKIndia]

"header of the subtotal." means you also want to remove name from field area so you can remove name and keep space instead of it as i could only understand your query. 

Could you please explain your query in more detail and provide report link if possible after keeping that report or sample data report in dropbox or provide more screenshot.

[Viksha]

Hi @HKIndia , unfortunately I won't be able to share the file, but to your suggestion - is there a way to rename totals in a pivot? isn't is avilable on field level, and then it will change the header of the regular row (not subtotal)?

[ManuelBolz]

Hello Viksha,

i'm not sure if I understand your problem correctly. But maybe you could solve your problem with field parameters?

Microsoft Learn - Power BI field parameters

Parameter = {
    ("B2B", NAMEOF('tablename'[Measurename1]), 0),
    ("Recalls (#)", NAMEOF('tablename'[Measurename1]), 1),
    ("MOM%", NAMEOF('tablename'[Measurename1]), 2),
    [...]
}

[Viksha]

Hi @ManuelBolz , I'm looking for a way to remove this subtotal, but keep all the others - 

[v-xinruzhu-msft · Accepted solution]

Hi,

Thanks for the solutions @HKIndia  and @ManuelBolz  provided, and  i want to offer some more information for user to refer to.

hello @Viksha , after testing, it cannot directly hide the subtotal, the only way is to set the subtotal color to white, and set it will affect the the header, but if you apply this, the value in matrix will be affected.

Output

So it is better that just make the value of the subtotal to white.

Output

Best Regards!

Yolo Zhu

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