Matrix Visual – Avoid Totals on Branches Without Further Levels

[Nazdac2024]

Hi everyone,
I’m working with a matrix visual based on an unbalanced hierarchy (some branches go deeper than others).

Is there a way to hide the repeated “Total” rows for branches that don’t continue to the next level?

Right now, even when a branch ends at, say, Level 2, the matrix keeps showing blank or repeated “Total” rows for Level 3, 4, and 5 — even though there's nothing more to drill into.

Thanks in advance!

[MasonMA]

@Nazdac2024 

Hi, You may try:

1. Under Row subtotals have both 'Row subtotal' and 'Per row level' turned On, 

then Under 'Apply settings to', for 'Show sutotal' under 'Rows' only have 'Show Subtotal' set to ON for those row levels you wanted to show on Matrix. 

Hope this helps:) 

[MFelix · Accepted solution]

Hi @Nazdac2024 ,

This depends on how you have your hierarchy build and on the measures that you are using.

Check this video that allows you to do that with 2 additonal measures on your model and an adjustment on your calculaition.

https://www.youtube.com/watch?v=RTDKQQI9vUA

I have made a small example in the PBIX attached

[v-tejrama]

Hi @Nazdac2024 ,


Thank you @MasonMA and @MFelix  for the response provided!
Has your issue been resolved? If the response provided by the community member addressed your query, could you please confirm? It helps us ensure that the solutions provided are effective and beneficial for everyone.

Thank you for your understanding!

[v-tejrama]

Hi @Nazdac2024 ,

I hope the above details help you fix the issue. If you still have any questions or need more help, feel free to reach out. We’re always here to support you.

Thank you.

[v-tejrama]

Hi @Nazdac2024 ,

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions.

Thank you.