Forum Discussion

sebastien85's avatar
sebastien85
New Member
1 year ago
Solved

Show table with +/- to develop hierarchy

Hi, I have a table of data like : Parent Child Col_Value_1 Col_Value_2 Col_Value_3 parent1 parent1 1 10 100 parent1 child1 2 20 200 parent1 child2 3 30 300 parent1 c...
Need Help
  • v-achippa's avatar
    v-achippa
    1 year ago

    Hi sebastien85 

    Thank you for reaching out to Microsoft Fabric Community.

     

    • By default, Power BI aggregates the values (e.g., summing subchild values when collapsing Child2).
    • The exact behavior you described (displaying only the value of the collapsed node without summing sub-levels) cannot be achieved with default visuals in Power BI.
    • The Matrix visual will always aggregate child values when a parent node is collapsed.
    • Use a custom visual like Matrix Pro or HierarchySlicer from the Power BI Marketplace to gain better control over hierarchical behavior.

     

    If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it! 

     

    Thanks and Regards,

    Anjan Kumar Chippa

sebastien85's avatar
sebastien85
New Member
1 year ago

thanks for your help.

I have use PATH but I want a compact colonne because I can have 15 levels of hierarchie and lot of colomns value.

When I undevelop "child2" the matrix do sum of subchild value. I want to display always "child2" value

 

  • v-achippa's avatar
    v-achippa
    Community Support
    1 year ago

    Hi sebastien85 

    Thank you for reaching out to Microsoft Fabric Community.

     

    • By default, Power BI aggregates the values (e.g., summing subchild values when collapsing Child2).
    • The exact behavior you described (displaying only the value of the collapsed node without summing sub-levels) cannot be achieved with default visuals in Power BI.
    • The Matrix visual will always aggregate child values when a parent node is collapsed.
    • Use a custom visual like Matrix Pro or HierarchySlicer from the Power BI Marketplace to gain better control over hierarchical behavior.

     

    If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it! 

     

    Thanks and Regards,

    Anjan Kumar Chippa

    • v-achippa's avatar
      v-achippa
      Community Support
      1 year ago

      Hi sebastien85,

      As we haven’t heard back from you, we wanted to kindly follow up to check if the solution I have provided for the issue worked? or let us know if you need any further assistance?

      If my response addressed, please mark it as Accept as solution and click Yes if you found it helpful.

       

      Thank you for being a part of the Microsoft Fabric Community Forum!

       

      Thanks and Regards,

      Anjan Kumar Chippa

      • v-achippa's avatar
        v-achippa
        Community Support
        1 year ago

        Hi sebastien85,

         

        We wanted to kindly follow up to check if the solution I have provided for the issue worked. If the issue is resolved, please mark the solution as Accept as solution to help the other members of the community find it more quickly. Don't forget to give a "Kudos" – I’d truly appreciate it! 

         

        Thank you for being a part of the Microsoft Fabric Community Forum!

         

        Thank and Regards,

        Anjan Kumar Chippa