Dynamic Org Hierarchy Dashboard

Create an Org chart or org structure in Power BI Dashboard which includes below

I want each manager’s (Manager 1) entire footprint which should include his:

1. Span of control (Direct Reports and Indirect Reports) for each manager under Manager 1
2. Span by Location
3. Span by Layers
4. Open and Filled positions
5. Drill down org structure

Example: Rahul Mehta’s Span of control, Span by Location, his layers, how much open and closed positions does he have.

If you have experience designing hierarchy visuals—Org Chart custom visuals, decomposition trees, graphs, cards or similar—let me see a sample when you respond. I’m ready to provide the spreadsheets as soon as we agree on the approach, and I’m looking forward to a clean, user-friendly result.