Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
AltGr9
Helper I
Helper I

Drillthrough from one field to another

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

 

Employee NumberName

Manager Number

1John

24

2Alice

24

24ManagerMan

56

56CEOGuy

NULL

 

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

Employee NumberName

Manager Number

1John

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?

1 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]))

MFelix_0-1696924848808.png

Please see file attach.


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



View solution in original post

5 REPLIES 5
MFelix
Super User
Super User

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?


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



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 NumberName

Manager Number

1John

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 NumberName

Manager Number

24ManagerMan

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 NumberName

Manager Number

1John

24

2Alice

24

 

John

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]))

MFelix_0-1696924848808.png

Please see file attach.


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



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.


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



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

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

AugPowerBI_Carousel

Power BI Monthly Update - August 2024

Check out the August 2024 Power BI update to learn about new features.

August Carousel

Fabric Community Update - August 2024

Find out what's new and trending in the Fabric Community.