Having 2 slicers, but only one allowed to be selected
Is it possible to have 2 slicers, but to have only one of them active at the same time.
Let's say I have a slicer 1 and slicer 2. If the user selects a value from slicer 1, then slicer 2 should be reset and the user should not be able to filter the data with the slicer 2. Same goes for slicer 2: If a user selects a value from slicer 2, then slicer 1 shouldn't be used.
We can set the slicer to make it not affect the report. Just like the following screenshot, when you select the circle button, the slicer will not affect the report. When you use slicer1, you can make slicer2 not affect the report. When you use slicer2, you can make clicer1 not affect the repport.