Forum Discussion
Nazdac2024
Advocate I
Advocate IMatrix Visual – Avoid Totals on Branches Without Further Levels
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 contin...
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
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.
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.