Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.
Solved! Go to Solution.
You just need to create a hierarchy, then "expand all down to one level in hierarchy" in matrix.
Regards,
You just need to create a hierarchy, then "expand all down to one level in hierarchy" in matrix.
Regards,
Hi @nmck86,
There is similar tread on how to create a hierarchy in power bi, hope it helps:
Regards
Abduvali
User | Count |
---|---|
122 | |
109 | |
97 | |
60 | |
57 |
User | Count |
---|---|
138 | |
116 | |
102 | |
70 | |
57 |