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.

v-pnaroju-msft's avatar
v-pnaroju-msft
Icon for Community Support rankCommunity Support
1 year ago

Thankyou, govind_021, Shahid12523, and Nabha-Ahmed, for your responses.

Hi katina,

We appreciate your inquiry submitted through the Microsoft Fabric Community Forum.

Based on my understanding of the issue, please find attached a screenshot and a sample PBIX file that may help resolve the problem:


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

Thank you.

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

Hi v-pnaroju-msft 

Thank you so much for the pbix you provided! I tested it, and it almost works...

However, when I modify your matrix and add departments to the rows, the blank rows are still visible in the ragged hierarchy:

Could you modify the measure, please? It would help a lot!
-katina