Slicer issue

Thank you for the very useful information from djurecicK2.

Hi sbott ,

As djurecicK2 said, the problem you describe is the default behavior of the slicer. In the sample data I created, since the customer and item tables are filtered in a single cross-filter direction, when you select the customer id again, there will still be the project code for the previous customer. In this case, the slicer retains the last selections unless you manually clear or reset them.

Here's an easy way to do it, by changing from a single cross-filter direction to both cross-filter direction：

Then, this is the behaviour of the slicer you were originally confused about :

When filtering in both cross-filter direction, the final result is as follows: when you select a customer in the Customer slicer, the Project slicer automatically updates to show only the projects associated with that customer. Similarly, when you select a project in the Project slicer, the Customer slicer automatically updates to show only the customers associated with that project:

Best Regards,
Zhu
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!