Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello everyone. Got a bit of an interesting issue.
I have a table that has a manager name in one column, and staff reporting to that manager in the second column. I am after a way to display this in Matrix visual so that once the manager is expanded, it shows the staff reporting to the manager. Problem is, there are examples where the staff are themselves manager of other staff.
For example, consider the following table:
It is giving me a result in this manner:
Ideally, I would like Emp A to be further expanded to Emp B and then in the same row, Emp B to be expanded to their relevant staff. so that when I collapse it, Emp A should also show the sum of items for Emp B staff.
Solved! Go to Solution.
Hi,
I am not sure how your semantic model looks like, but you can try to use below DAX functions as a starting point of your solution.
Please check the below picture and the attached pbix file.
PATH function (DAX) - DAX | Microsoft Learn
PATHITEM function (DAX) - DAX | Microsoft Learn
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
Hi,
I am not sure how your semantic model looks like, but you can try to use below DAX functions as a starting point of your solution.
Please check the below picture and the attached pbix file.
PATH function (DAX) - DAX | Microsoft Learn
PATHITEM function (DAX) - DAX | Microsoft Learn
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
Hi @Jihwan_Kim Thank you so much mate. I never knew about the path function. This has done the trick for me cheers for that.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
95 | |
94 | |
79 | |
71 | |
64 |
User | Count |
---|---|
120 | |
105 | |
99 | |
81 | |
72 |