Show table with +/- to develop hierarchy

[sebastien85]

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

[lbendlin]

Why not use the PATH functions?

[sebastien85]

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 · Accepted solution]

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]

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]

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

[v-achippa]

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. 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!

Thanks and Regards,

Anjan Kumar Chippa