Forum Discussion
MOUNICA_BV
1 year agoFrequent Visitor
Manager to employee filtering using slicer
Hi,
I have come across a requirement where
I have table with empid,empname,managerid
So in report I will show 3 columns in a table and a slicer based on empid.
Now when I select one empid, the respective row will be shown in table but when I choose an empid who is also a manager then all employees under him also should be shown in the table.some employees are top-level,they don't have a manager.
Please let me know how to implement this.
sample data
Empid Empname Managerid
100 Abc
101 XYZ 100
102 MMM 100
104 DDD 106
105 EEE 106
106 KKK
Easy enough,
3 Replies
- ThxAlot
Super User
- rajendraongole1
Super User
Hi MOUNICA_BV - Please check the attached pbix file.
also please check the solution provided by ThxAlot
Thank you
- MOUNICA_BVFrequent Visitor
rajendraongole1 I have checked ur pbix file.Its not filtering correctly for manager.Anyways I figured out the solution.Thanks