Help with Child/Parent Hierarchy from SharePoint

[drewdev]

I'm trying to visualize child/parent heirarchy in Power BI visuals and not the most efficient way to set this up. Any guidance would be much appreciated as I'm a newbie to this type of stuff in PBI.

I have ID#52 marked as a Parent item (true)

And all child records marked with 52 in the "ParentID" field

Essentially - I want to display 52 as the main line item in PBI, and then have the below records show underneath so that I can expand/minimize to save space.

Is there an easy way to set this up? Is there a certain visual that works better? 

Again - thanks everyone for any assistance you can provide!!

-Andrew

[j_ocean]

If it's just one one possible level a matrix visual will work. 

Otoh if you have an undefined number of levels e.g. 250 may be a parent of something else, or you want to bring the parent's info into the same row, then you can try flattening the table in PQ by progressvely merging copies of itself. It's inelegant and you're effectively hard coding a maximum that isn't enforced in your source system but it does get the job done.

[chonchar]

@drewdev 

Use a matrix rather than a table. Then the matrix will create those hierarchies for you with little plus signs.