Drillthrough from one field to another

[AltGr9]

I have a simple table of employees that looks like this:

Employee Number	Name	Manager Number
1	John	24
2	Alice	24
24	ManagerMan	56
56	CEOGuy	NULL

What I have is a report that drills through on employee, to show only one employee like this: 

Employee Number	Name	Manager Number
1	John	24

 What I want is to be able to click on this employee, and for it to drill-through to Employee Number 24, to show the manager.

Is this possible?

[MFelix]

HI @AltGr9 ,

When you refer that you want to click the employee are you refering to a single action? Or you did not setup the drill trough in Power BI report?

[AltGr9]

Hi Miguel,

No I'm not talking about a single action. I'm talking about a drill through. Yes I've set up the drillthrough. The issue is that the Manager's employee ID is located in a different field to the Employee ID field. So lets say I've already drilled through on John, using the Employee Number field. That will show me the following table:

Employee Number	Name	Manager Number
1	John	24

I want to click this row and get to drill through to employee 24. The problem is I can't drill through on the Manager Number field, because the manager doesn't have a manager number of 24. The manager has a Manager Number of 56. Here is the manager's row:

Employee Number	Name	Manager Number
24	ManagerMan	56

If I were to drillthrough on the Manager field, it would give me the following, but I want it to show me the Manager, not that manger's team:

Employee Number	Name	Manager Number
1	John	24
2	Alice	24

John

[MFelix · Accepted solution]

Hi @AltGr9 ,

Being a drill trough page you can use a metric similar to the one below:

Manager name = LOOKUPVALUE(Demo[Name], Demo[Employee Number], SELECTEDVALUE(Demo[Manager's Employee ID]))

Please see file attach.

[MFelix]

Can you please share a mockup data or sample of your PBIX file. You can use a onedrive, google drive, we transfer or similar link to upload your files.

If the information is sensitive please share it trough private message.

[AltGr9]

Hi, sure, here is a one drive link to the file:

https://infinis-my.sharepoint.com/:u:/p/john_altamura/EfmcBmWYehdMj4TbnQe_W_IBo-SEAb1yngSB-ZLbVjuNqg...

Let me know if the link doesn't work for you.

John