Skip to main content
Microsoft Idea

Power BI

Completed

single selection slicer

Vote (1421) Share
richard's profile image

richard on 12 Feb 2016 12:30:42

The ability to configure a slicer to only be able to select one attribute at a time - similar to a radio button. I would like to disable the ability for people to either choose select all or choose multiple slicers.

Administrator on 01 Apr 2019 23:45:42

Hi everyone! The slicer now supports a radio button mode too, with real single-select behaviour. You'll see updated options in the property pane that let you control this. Thanks for your patience and feedback!

Comments (94)
richard's profile image Profile Picture

Matthias Power BI User on 05 Jul 2020 23:33:09

RE: single selection slicer

This is really important to create a great user experience by avoiding states of the dashboard that make no sense ...

richard's profile image Profile Picture

Rob Wolf on 05 Jul 2020 23:30:43

RE: single selection slicer

This is especially important for a Year to Date visual. When multiple years are chosen it can bomb the visual. Not a great user experience. I assume there is a work around in DAX, but still it certainly increases complication.

richard's profile image Profile Picture

Anonymous on 05 Jul 2020 23:30:26

RE: single selection slicer

Need this feature. Very useful.

richard's profile image Profile Picture

Power BI User on 05 Jul 2020 23:26:57

RE: single selection slicer

The user should not be able to force multiple options using the Ctrl key if single selection has been applied.

richard's profile image Profile Picture

David Williams on 05 Jul 2020 23:26:52

RE: single selection slicer

Same as Scott - Change the visual from squares (which indicates multi select to end users) to radio buttons (which indicates single select to end users)

richard's profile image Profile Picture

Timothy Hart on 05 Jul 2020 23:26:22

RE: single selection slicer

Currently, despite people having the option to limit a slicer to one option, users can still force select multiple (or no) options using the CTRL key, which can cause havoc in other tables/charts/cards. Please fix so we can force one selection.

richard's profile image Profile Picture

Rafael Borghi on 05 Jul 2020 23:23:50

RE: single selection slicer

Same as Scott Powell, we should be able to choose from single to multi selection.

richard's profile image Profile Picture

Power BI User on 05 Jul 2020 23:22:05

RE: single selection slicer

Please add this

richard's profile image Profile Picture

João Rezende on 05 Jul 2020 23:21:50

RE: single selection slicer

Same as Scott Powell, if I want single selection, then it shouldn't be possible to select all, there should always be something selected or nothing at all.

richard's profile image Profile Picture

Power BI Ideas Admin on 05 Jul 2020 23:21:26

RE: single selection slicer

Additionally, if Select All is enabled: when Select All is not chosen, and no other selection in the slicer is made, no results should be returned! It is confusing to the end user when Select All and No Selection displays the same results