Forum Discussion
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 | child3 | 4 | 40 | 400 |
| child2 | subchild1 | 5 | 50 | 500 |
| child2 | subchild2 | 6 | 60 | 600 |
| parent2 | parent2 | 7 | 70 | 700 |
| parent2 | child4 | 8 | 80 | 800 |
I want have au table to show the hierarchy of "parent" and "child" columns and linked data like this when data are developped :
like this when data are not developped :
I have try with a table visual but is not possible to develop / undevelop line.
I have do the same with a matrix, but I have error dans can't use conditionnal custom of coloum.
Have do something like this ?
Can you help me ?
Thanks you
Bests regards
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
6 Replies
Why not use the PATH functions?
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
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
