Forum Discussion
Solved
Power Query - flatten Parent-child hierarchy
I have a parent-child hierarchy table. I don't know in advance how many levels there are. I need help with building a function that would flatten the levels. I found this very helpful post: https:...
I've solved it with a help of LivioLanzo solution to this post.
https://community.powerbi.com/t5/Desktop/Parent-Child-Hierarchy-Highest-Parent-using-Power-Query-not-DAX/td-p/519919It's dynamic, not fixed solution.
Hey how do you integrate/ define relationship between actual table data and this data in the bi visuals.
I had a data table which had parentid and childid, I used this and created the levels and added it to slicer now I want my visual to show me data related to only the selected childid or group id.Any idea on this