Force user to select single slicer in a dashboard of multiple slicer.

[maqsud]

I have dashboard with multiple slicer (Checkbox mode) For example: "Location Slicer", "Gender Slicer" and "Age Slicer". 

If I have to choose option from "Location Slicer". I want other slicer to be disable for further selecting Filter. As i want to restrict the privacy of data.

So Is it possible to select only Single Slicer at a time in PowerBi. If there is any custom visual is available then that would be fine.

I want that after selecting "Mumbai" from Location Slicer (Red Mark). Other Slicer should be disable to select (Blue Slicer). As User can only select one filter at a time.

Best Regards,

Maqsud Inamdar

Data Analyst Intern

TheOther 2 Thirds Consulting LLP.

[v-diye-msft · Accepted solution]

Hi @maqsud 

I don't think there's a better way to reset the other filters/slicers at the same time. bookmark could be a workaround, but troublesome to some extent. 

you can refer to the similar thread for more hints:

https://community.powerbi.com/t5/Desktop/Have-user-select-only-only-one-slicer-or-filter/td-p/176905 

https://community.powerbi.com/t5/Desktop/Always-one-value-selected-in-Slicer/td-p/60275 

[Greg_Deckler]

I am not aware of a way to do what you are asking. I generally find that twisting the user's arm until they do what I want works wonders! 🙂

[amitchandak]

I did not get it completely. But Refer if bookmark can help

https://radacad.com/bookmarks-and-buttons-making-power-bi-charts-even-more-interactive