Automatic Filtering for Slicers

Hi SHA03 ,

Thank you for reaching out to Microsoft Fabric Community.

Thank you FarhanJeelani for the prompt response.

Here are few steps to solve the issue:

1.Create a Disconnected Employee Table
Go to Modeling > New Table 

EmployeeList = DISTINCT(EmployeeTable[Employee Number])

This table will act as your slicer source.

2.Create a slicer from this new EmployeeList table
Use EmployeeList[Employee Number] in your slicer.

3.Create measures for selected department and level
These will pull values based on the slicer:

Selected_Dept =
VAR _Emp = SELECTEDVALUE(EmployeeList[Employee Number])
RETURN CALCULATE(
MAX(EmployeeTable[Department]),
FILTER(EmployeeTable, EmployeeTable[Employee Number] = _Emp)
)

Selected_Level =
VAR _Emp = SELECTEDVALUE(EmployeeList[Employee Number])
RETURN CALCULATE(
MAX(EmployeeTable[Level]),
FILTER(EmployeeTable, EmployeeTable[Employee Number] = _Emp)
)

4.Add visual-level filters to your “Same Dept” and “Same Level” visuals
For “Same Department” visuals, add a filter:

EmployeeTable[Department] = [Selected_Dept]

For “Same Level” visuals:

EmployeeTable[Level] = [Selected_Level]

This works because the disconnected slicer doesn't interfere with the visuals, but your measures still pull the needed values for filtering.

If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it! 

Thank you.