Slicers working together

Hi  Anonymous ,

According to your description, I create some data:

You can create the same table and set the filter direction between the table and the table to one-way

Here are the steps you can follow：

1. Create calculated table.

Calculated Table = 'Main Table'

2. Set the relationship between Main Table and Calculated Table in Model to be many-to-many, and Main Table unidirectionally filter Calculated Table

Result:

3. Use the practices of the Main Table as the slicer and the Provides of the Calculated Table as the other slicer

4. Result.

When the practices slicer is selected as practices A, the other slicer will change

When the provides slicer is selected as provides1, the other slicer will not change

You can downloaded PBIX file from here.

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.