Slicer to filter table in 2 columns

[tssi70]

To simplify the issue I have a "Call"-table with 2 columns: "EmployeeReceiver" and "EmployeeHandler". Then I have created a new table "Employee" that holds the distinct values from the 2 columns in the "Call"-table. For the "Employee"-table I have added a Slicer.

Now, when 2 or more selections is made in the Slicer I want to display only records from the "Call"-table that have both the "EmployeeReceiver" AND the "EmployeeHandler" among the selected employees in the Slicer. Is this possible and if so how can I do this?

[v-yuezhe-msft]

Hi @tssi70,

Could  you please share sample data of  the two tables ("Call" table and "Employee" table) and post expected result here?

Besides, we need to know that what field you use to create relationship between “Call” table and "Employee" table, and which field you drag into the slicer.


Thanks,
Lydia Zhang

[tssi70]

Surtenly 🙂
Fictive names here.

"Call"-table:
EmployeeReceiver   EmployeeHandler

Employee1               Employee2

Employee1               Employee3

Employee1               Employee4

Employee2               Employee3

Employee2               Employee4

"Employee"-table:

Here the table is just created with an sql like SELECT DISTINCT EmployeeName FROM (SELECT EmployeeReceiver AS EmployeeName FROM Call UNION ALL SELECT EmployeeHandler AS EmployeeName FROM Call) AS Employee.

If the Slicer has selection on Employee1 and Employee2 I only want to see that first row in the Call-table.

The Relationship is a problem as I would like to have 2:

- Call.EmployeeReceiver -> Employee.EmployeeName

- Call.EmployeeHandler -> Employee.EmployeeName.

Tried with both (1 non active) and without any, but no luck.

[tssi70]

@v-yuezhe-msft it might be some completely other way to do this, but I'm not aware of it.

[v-yuezhe-msft · Accepted solution]

Hi @tssi70,

Based on my test, it is impossible to achieve your requirement using one slicer. You can create another slicer using EmployeeReceiver field and use two slicers to filter your visual. You can check the example in the following screenshot.

Thanks,
Lydia Zhang