Hierarchies IN Power BI from Excel

[nmck86]

Hi All,

I am working with an excel file (Attached).. that I would like to show up in Power Bi with the same drill downs. So in the images below you will notice in Excel we have a hierarchy based on the level of the employee. In this example level 2 is the highest level of hierarchy and she is the immediate manager of 4 employees (in bold) and the indirect manager of the 4 managers in bolds direct reports. so the format below is the exact format I would LOVE to see in Power BI. However, I can not get it to work that way in Power BI. Does anyone have thoughts on how to do this? I have the excel file but wasn't sure how to add it here but can send to anyone who can assist. Please feel free to ask any questions you may have.

[v-sihou-msft · Accepted solution]

@nmck86

You just need to create a hierarchy, then "expand all down to one level in hierarchy" in matrix. 

Regards,

[Abduvali]

Hi @nmck86,

There is similar tread on how to create a hierarchy in power bi, hope it helps:

• https://community.powerbi.com/t5/Desktop/Creating-a-Hierarchy-in-Power-BI/td-p/49093

Regards

Abduvali