Forum Discussion

Nazdac2024's avatar
Nazdac2024
Icon for Advocate I rankAdvocate I
1 year ago
Solved

Matrix 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...
Need Help
MFelix's avatar
MFelix
Icon for Super User rankSuper User
1 year ago

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    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!

    • Anonymous's avatar
      Anonymous
      Not applicable
      1 year ago

      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.

      • Anonymous's avatar
        Anonymous
        Not applicable
        1 year ago

        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.