Skip to main content
cancel
Showing results for 
Search instead 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

Reply
Viksha
Frequent Visitor

Show selected row-subtotals in a pivot table

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: 

 

Viksha_0-1716728841509.png

 

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

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

vxinruzhumsft_0-1716865655079.png

 

Output

vxinruzhumsft_1-1716865665880.png

 

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

vxinruzhumsft_2-1716865722309.png

 

Output

vxinruzhumsft_3-1716865730327.png

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.

 

 

View solution in original post

5 REPLIES 5
HKIndia
Helper I
Helper I

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

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
Responsive Resident
Responsive Resident

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),
    [...]
}

 

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

Viksha_0-1716728801796.png

 

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.

vxinruzhumsft_0-1716865655079.png

 

Output

vxinruzhumsft_1-1716865665880.png

 

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

vxinruzhumsft_2-1716865722309.png

 

Output

vxinruzhumsft_3-1716865730327.png

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.

 

 

Helpful resources

Announcements
Europe Fabric Conference

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.

July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.