Forum Discussion
Slicer to filter table in 2 columns
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?
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
4 Replies
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 ZhangSurtenly :-)
Fictive names here."Call"-table:
EmployeeReceiver EmployeeHandlerEmployee1 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.
Anonymous it might be some completely other way to do this, but I'm not aware of it.
