Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

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?

 

 

 

 

 

  • Anonymous's avatar
    Anonymous
    4 years ago

    Hello Super User

    Got it to work! 

    Much appreciate your help!

     

    Thank you

     

     

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hello Super User

    Got it to work! 

    Much appreciate your help!

     

    Thank you

     

     

  • Anonymous,

     

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

     

     

    Year - on

    Quarter - on

    Month - off

    Week - off