Forum Discussion
Hierarchy from multiple tables
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.
Alexandra_B , Append then in single table and use path and path length in DAX
https://www.sqlbi.com/articles/clever-hierarchy-handling-in-dax/
3 Replies
Alexandra_B , Append then in single table and use path and path length in DAX
https://www.sqlbi.com/articles/clever-hierarchy-handling-in-dax/
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 😞
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!
