Forum Discussion
azakir
2 years agoResolver I
Reporting Lines - Matrix Visual
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 thi...
- 2 years ago
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
Jihwan_Kim
2 years agoSuper User
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
- azakir2 years agoResolver I
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.