Parent and Child visualisation

[tstraker]

HI All,

I'm struggling to visualise Parent / Child relationships.

I have a query called work, it has two columns:

1. ItemID
2. ParentItemID

I want to simply display each parent (ParentID) and then have a drill down into its children (ItemID).

Ideally I'd use a tree chart or an org chart but I can't find anything thats really working.

How should I be approaching this?

[v-lili6-msft · Accepted solution]

HI, @tstraker 

You could get it by using Drill mode in a visualization in Power BI

https://docs.microsoft.com/en-us/power-bi/consumer/end-user-drill

And you could also download custom visual from marketplace such as: Treeviz...

https://appsource.microsoft.com/en-us/marketplace/apps?page=1&src=office&product=power-bi-visuals

Best Regards,

Lin