Forum Discussion

katina's avatar
katina
Icon for Helper II rankHelper II
1 year ago
Solved

Help Needed with Visualizing Managerial Headcount Hierarchy in Matrix – Handling Variable Depths

Hi everyone, I'm working on a Power BI report where I need to visualize headcounts per department and per manager. The goal is to use a matrix to show active employees under each manager, summarized...
Need Help
Tips and Tricks
  • v-pnaroju-msft's avatar
    v-pnaroju-msft
    1 year ago

    Hi katina,

    Thank you for your follow up.

    Please find attached a screenshot and a revised sample PBIX file that may help resolve the issue:


    We hope the information provided is useful. If you have any further queries, please feel free to contact the Microsoft Fabric community.

    Thank you.

Shahid12523's avatar
Shahid12523
Icon for Community Champion rankCommunity Champion
1 year ago

Unpivot your hierarchy columns (Level1 to Level6) in Power Query so they become rows instead of columns.
👉 Filter out nulls so only actual manager names show in the matrix.
👉 This makes the matrix dynamically adjust to each manager’s depth—no more clutter from blank levels.

  • katina's avatar
    katina
    Icon for Helper II rankHelper II
    1 year ago

    This sounds clever, I'll try it right now and comment then. Thanks!

  • katina's avatar
    katina
    Icon for Helper II rankHelper II
    1 year ago

    Unfortunately Anonymous , this approach almost works. However, now I have also the department manager and that person's manager (CEO) being calculated to the headcount with all their subordinates.

    Do you have idea, what and how to modify? I'll create a dummy illustration, one moment...