Forum Discussion
Clear all slicer selection when single select is enabled
Hi All,
Is there a way to clear all slicer selection when single select is enable? for all slicers?
I have tried to do this with the bookmark but i am not able to do that.
Thank you,
Abrarali Surti
Hi Anonymous ,
You may turn off the "Single select" under Selection controls in Format option, then you can make other selections in slicer visual.
Or you may use "Edit interactions" feature to choose which visuals to be filtered by one special visual. See more details: https://docs.microsoft.com/en-us/power-bi/service-reports-visual-interactions.
Best Regards,
Amy
Community Support Team _ Amy
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
8 Replies
I realize this is quite old, but to help a bit here:
this configuration:
will act for 99% of users like a single select that you can clear by "unselecting" it, and only if a user knows to hold the CTRL key will they be able to multi-select. This solved this problem for me, so just leaving this here in case it helps someone else.
Super helpful! Solved the issue I was having.
v-xicaiCommunity Support
Hi Anonymous ,
You may turn off the "Single select" under Selection controls in Format option, then you can make other selections in slicer visual.
Or you may use "Edit interactions" feature to choose which visuals to be filtered by one special visual. See more details: https://docs.microsoft.com/en-us/power-bi/service-reports-visual-interactions.
Best Regards,
Amy
Community Support Team _ Amy
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
THANK YOU!!!
- Arul
Super User
Hi Anonymous ,
When you select single select option in format pane, it will automatically clear all the filters in your filter visual.
Thanks,
-Arul
Hi Arul
I have the Unit slicer (with Single select enabled) i want to clear the "CardiovascularIntensivercareUnit" so that i can select other units.
I don't think theres a way to do it... but if there are multiple visuals, you can set this filter to work on all visuals, and the other filters you can set them to only work on some of the other visuals. That can be done by selecting the filter you dont want to work on a particular visual, going to the format tab and using edit interactions. That's the only way I was able to solve a similar problem
I have found that you cannot clear a single select slicer, something will always be selected.
However I had a user requirement that a visual must be empty until one and only one selection is chosen from a slicer. This required a workaround.
I used a normal multi-select drop down slicer :
With ctrl + click for multi select On, just to make it more difficult to attempt selecting more than one and "Select All" off because that went against the user requirement immediately. Single select off, to allow the filter to be cleared with a "Clear Filters" button.
Then use a measure, applied to the visual as a filter to show information only when a single selection is chosen.
single_ID_selected = CALCULATE( // Check if there is exactly one PersonID selected IF( // Ensure that the PersonID column is being filtered AND(ISFILTERED(all_the_data[PersonID]), // Check if the number of distinct PersonID values is exactly 1 DISTINCTCOUNT(all_the_data[PersonID]) = 1), 1, // Return 1 if both conditions are true 0 // Return 0 if either condition is false ), // Apply all existing filters in the current context ALLSELECTED(all_the_data) )In addition to that when the visual was blank there was a user instruction text box which said "Select a single person ID from the filter" If the user pressed CTRL + click on a second person ID the visual would go blank and the user instruction reappears as a reminder of the functionality.
