Hierarchy from multiple tables

[Alexandra_B]

Hello. Help, please!

I have a number of tables in Power BI desktop (loaded JSON files).

Each files contains the same columns, but with different values.

Please see in the picture above how I need them corellated.

Each parent and child is a JSON file, therefore a table, so I have 20 tables.

How could I link them to create a hierarchy as described?

Each table contains the following.

After I create a hierarchy, I would like to add a filter, so whenever the client selects a Parent, he can go deeper into children`s data/ sub-children if related.

Please, please, tell me there is an option as I`ve been searching a lot and cannot find an answer. 😞

Thank you in advance.

[amitchandak · Accepted solution]

@Alexandra_B , Append then in single table and use path and path length in DAX

https://radacad.com/parsing-organizational-hierarchy-or-chart-of-accounts-in-power-bi-with-parent-ch...

https://www.sqlbi.com/articles/clever-hierarchy-handling-in-dax/

[Alexandra_B]

@amitchandak, I`ve sorted it out with Merge and followed the steps from links (path and pathlength). Then I created a relationship between the hierarchy table and the unpivoted merged table and it works. Thank you for your help!

[Alexandra_B]

@amitchandak, thank you.

I have apended them in a single table, but how do I differentiate them?

 I have tried to merge them, but I`m getting lost at "Join kind" and then it`s taking ages to load 😞