The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event: Join us in Stockholm, September 24-27, 2024.
Save €200 with code MSCUST on top of early bird pricing!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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?
Solved! Go to 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.
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHI @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
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi 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
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.
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsCan 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
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi, sure, here is a one drive link to the file:
Let me know if the link doesn't work for you.
John
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the August 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
80 | |
66 | |
53 | |
52 |
User | Count |
---|---|
121 | |
117 | |
77 | |
64 | |
63 |