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.
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?
Solved! Go to 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
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
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.
@v-yuezhe-msft it might be some completely other way to do this, but I'm not aware of it.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
99 | |
80 | |
70 | |
59 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |