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

Raghavender Papisetty on 08 Sep 2021 14:18:09

RE: single selection slicer

Really required feature. Can Microsoft can consider?

richard's profile image Profile Picture

Santiago on 06 Jul 2020 00:15:20

RE: single selection slicer

Hi everyone,

Could someone please tell me where I can find the "property pane" in which it is possible to enable the option to configure the slicer so it has a single-select behaviour?

Thanks in advance.

richard's profile image Profile Picture

Andrew on 06 Jul 2020 00:13:51

RE: single selection slicer

Would really be great to see this feature in the filters pane too, to match slicers! If a user chooses "single select" from the filter in the filter pane, they can still unselect their single selected option causing an entire data set to show for that filter!

richard's profile image Profile Picture

Power BI User on 06 Jul 2020 00:12:44

RE: single selection slicer

I'm not sure whats changed it still isn't possible to calendar select a single date, only available in list or dropdown mode. Surely its a simple change to have a single date select box .

richard's profile image Profile Picture

Kamil Suski on 06 Jul 2020 00:10:20

RE: single selection slicer

single select should have option "nothing selected" by default.

as it is now - 1st item on the list is automatically selected and there is no way to de-select it for default visual when someone just opens report.

as stated before - someone not having rights to see data corresponding to 1st item on the list will see blanks all over the place, and slicer visual having only available items + first one as already selected.

this default item is removed from slicer the moment user selects something he/she have access to ...

richard's profile image Profile Picture

Power BI User on 06 Jul 2020 00:07:58

RE: single selection slicer

I second the business need expressed below. We need to be able to limit to one selection but ALSO be able to select all as one of the radio buttons. PLEASE ADD THIS FUNCTIONALITY :)

Comment on March 24, 2019
"It doesn't work together with the option to "select all"
Please, could the "select all" option be added for working together with the radio button for a unified experience?"

richard's profile image Profile Picture

Pavel on 06 Jul 2020 00:04:57

RE: single selection slicer

I have a problem with Single Selection with RLS. For example, when i create report default value is Europe. And user have rls only for Africa. When user open the report he see Europe whith blank values.

richard's profile image Profile Picture

Martin Turcotte on 06 Jul 2020 00:04:06

RE: single selection slicer

What was really needed is the ability to select a SINGLE date using the EXACT calendar visual from the filter when in dates between mode. Offering BETWEEN, BEFORE and AFTER is not enough. EVERY business user wants the ability to select a SINGLE date using the calendar visual (existing and perfect for this because it allows to select the year, the month and then pick the date from the calendar page). SIngle radio button for other data types is nice, but SINGLE DATE is the missing link!

richard's profile image Profile Picture

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

RE: single selection slicer

It doesn't work together with the option to "select all"
Please, could the "select all" option be added for working together with the radio button for a unified experience?

richard's profile image Profile Picture

vinay kaky on 05 Jul 2020 23:44:35

RE: single selection slicer

Thanks team for including in March 2019 release. Itz working as expected.