Drill Through display list of related items

[Delphia]

Hi, dear community,

I have a problem with Drill Through option. 

On my report, I have a matrix and want to make drill through to another page based on Project_name.

If I do a right-click on "First Project" to see project details, I see only the name of the employee ("Jack") that is on the same row that the project on matrix (Row Context?).

But my goal is to find all information about this project. For example, list of employees that are involved in this project.

So, for the First Project it should be Jack and Robert. Nevertheless, I should take into account the date interval if it is chosen as filtre.

My data model looks like:

Please find my pbix file here: https://drive.google.com/file/d/10GZkmfqA6LVVRDpJP46kINSrzcLKph2s/view?usp=sharing

Thank you in advance for all your comments and ideas!

[aj1973]

Hi @Delphia 

You need to turn off Keep all filters and add project name to your matrix

[Delphia]

Also in this case all other filters that were applied did not work. For example, there is a client filter as well.

[aj1973 · Accepted solution]

Ok @Delphia do this

1 - change Direction, from single to both

2- Add field Client to the filters in the page

3- Add a visual for Client in your page

4- Drillthrough

[Delphia]

It works perfectly. Thank you so much!

[aj1973]

Welcome

[Delphia]

Thank you so much. But actually, I need only the list of employees, not matrix. Is there any possibility to show them as a list without any other attribute (like project name)?