cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
PBI-Curious
Resolver I
Resolver I

Row Subtotals - Per row level settings

Hello

 

Per the new upgrade to Power BI, I notice the Per row level Row Subtotals functionality has changed. I can't seem to figure out how it works.

 

Re: the screen shot belo

Apply settings to Per row level is On

Series -  Segment selected,  but in the visual I can still see the totals in Product, Discount Bank and Country.

 

How can I only show the Totals for Segments?

 

PBICurious_2-1649962023629.png

 

 

PBICurious_1-1649961647816.png

 

 

1 ACCEPTED SOLUTION
PBI-Curious
Resolver I
Resolver I

Hello Super User

Got it to work! 

Much appreciate your help!

 

Thank you

 

PBICurious_0-1650046864951.png

 

View solution in original post

2 REPLIES 2
PBI-Curious
Resolver I
Resolver I

Hello Super User

Got it to work! 

Much appreciate your help!

 

Thank you

 

PBICurious_0-1650046864951.png

 

DataInsights
Super User
Super User

@PBI-Curious,

 

I used a date hierarchy to mimic your hierarchy. In "Row subtotals", set "Rows - Show subtotal" for each level as follows:

 

DataInsights_0-1650032091622.png

 

Year - on

Quarter - on

Month - off

Week - off

 

DataInsights_1-1650032123423.png

 





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Helpful resources

Announcements
Winner of T-Shirt Design

Power BI T-Shirt Design Challenge 2023

Find out who won the T-Shirt Design Challenge and the top 3 finalists.

March 2023 Update3

Power BI March 2023 Update

Find out more about the March 2023 update.

Top Solution Authors