Manager to employee filtering using slicer

[MOUNICA_BV]

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 

[rajendraongole1]

Hi @MOUNICA_BV - Please check the attached pbix file. 

also please check the solution provided by @ThxAlot 

Thank you

[MOUNICA_BV]

@rajendraongole1 I have checked ur pbix file.Its not filtering correctly for manager.Anyways I figured out the solution.Thanks

[ThxAlot · Accepted solution]

Easy enough,