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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
Anonymous
Not applicable

How to get whenever we select particular employee in slicer we need to get manager information.

Hi All,

 

Scenario: We have Employee ID Slicer and Employee Level slicer. and Below we have table in that we need to have Employee ID Employeee name his Level and Manger Name.

 

Employee IDEmployee NameEmployee LevelManager IDManager Name
400Mahesh0  
401Kishore1400Mahesh
402Vijay1400Mahesh
403Suresh1400Mahesh
404Sunil2402Vijay
405Rakesh2403Suresh
406Shyam Sunder2401Kishore
407Gunjan3404Sunil
408Nitchala3406Shyam Sunder
409Srikar3405Rakesh
410Sai Kiran3404Sunil

 

Whenever we click on perticular employee ID (400) from the slicer, I need to filter the data in the table with the selected that is Mahesh and his details like below table.

 

Employee IDEmployee NameEmployee LevelManager IDManager Name
401Kishore1400Mahesh
402Vijay1400Mahesh
403Suresh1400Mahesh

 

And When I go to employee Level slicer there i can see (L1,L2,L3 Values), If i select Level L2, I need to do filter Like below table.

 

Employee IDEmployee NameEmployee LevelManager IDManager Name
401Kishore1400Mahesh
402Vijay1400Mahesh
403Suresh1400Mahesh
404Sunil2402Vijay
405Rakesh2403Suresh
406Shyam Sunder2401Kishore

 

Same like when I select Level 3 i need to get the data like below table.

 

Employee IDEmployee NameEmployee LevelManager IDManager Name
401Kishore1400Mahesh
402Vijay1400Mahesh
403Suresh1400Mahesh
404Sunil2402Vijay
405Rakesh2403Suresh
406Shyam Sunder2401Kishore
407Gunjan3404Sunil
408Nitchala3406Shyam Sunder
409Srikar3405Rakesh
410Sai Kiran3404Sunil

 

Request you to please help me on this Logic

 

Thanks in advance.

4 REPLIES 4
v-janeyg-msft
Community Support
Community Support

Hi, @Anonymous 

 

What's the logic when these two slicer "Employee ID Slicer and Employee Level slicer" are selected at the same time?

 

Janey

Anonymous
Not applicable

When we select Employee ID Slicer for example if i will select employee 401 that means it will get Kishore and his reporting manager Mahesh, after that i will go to Level slicer If i select Level "2" i need to get the data like whover is reporting to Kishore those information as well. then the table should become as like below. 

Employee IDEmployee NameEmployee LevelManager IDManager Name
401Kishore1400Mahesh
406Shyam Sunder2401Kishore

 

Hi, @Anonymous 

 

vjaneygmsft_0-1646213925084.png

vjaneygmsft_1-1646213955275.png

So for Employee ID Slicer, In addition to 400 choose 401, 402, 403, other choices only show the one you choose?

 

 

For Employee Level slicer, Why choose 3, the rows containing 1, 2, 3 will also appear,
So what happens when only 1 is selected? The row with 0 never appears?

vjaneygmsft_2-1646214088175.png

Although your table contains paths, your requirements seem to be more strange than the logic of paths, and it is difficult to unify the logic...You have to know that the two slicers will affect each other. I need a logic without loopholes. 

 

Janey

AllisonKennedy
Super User
Super User

@Anonymous  You could try using the PATH function in DAX for some of this, to create Level 1, Level 2, etc columns.


Please @mention me in your reply if you want a response.

Copying DAX from this post? Click here for a hack to quickly replace it with your own table names

Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C

I work as a Microsoft trainer and consultant, specialising in Power BI and Power Query.
www.excelwithallison.com

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

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