Skip to main content
Microsoft Idea

Power BI

Needs Votes

Slicer mandatory selection property

Vote (442) Share
's profile image

on 20 Jan 2016 07:23:34

A property called "Mandatory select" would be nice under "Selection Controls" for the slicer. This would enforce filtering if the underlying dataset is very big. At least one value must be selected at all times if this property is turned on.

Comments (50)
's profile image Profile Picture

Martin K. on 24 Nov 2022 07:45:55

RE: Slicer mandatory selection property

I see that this is a rather old thread, but anyways:Am I missing the point or isn't this implemented now (at least 2022) under "Format your visual" > Visual > Slicer settings > Selection > Single select?

's profile image Profile Picture

Terry Holschuh on 27 Oct 2020 15:09:33

RE: Slicer mandatory selection property

Hello,
Please add this mandatory filter default as soon as possible. We really need it for a very large client of ours.
Thanks!

's profile image Profile Picture

Alex Miles on 05 Jul 2020 23:46:48

RE: Slicer mandatory selection property

Just so you are all aware, if you have the available space in your report for a large slicer, the chiclet slicer has the capability to force selection.

's profile image Profile Picture

Power BI User on 05 Jul 2020 23:43:20

RE: Slicer mandatory selection property

No one's listening.. Possibly MS has turned deaf. ;)

's profile image Profile Picture

Danny Zumwalt on 05 Jul 2020 23:42:23

RE: Slicer mandatory selection property

Still waiting. This is embarrassing. So much work required to manually force a user to choose from a slicer.

's profile image Profile Picture

Vicky M on 05 Jul 2020 23:42:10

RE: Slicer mandatory selection property

This idea is created 3 years back.. someone listening :)
Please enable this feature...

's profile image Profile Picture

iurie on 05 Jul 2020 23:40:43

RE: Slicer mandatory selection property

this is a must!

's profile image Profile Picture

Rhonda Smart on 05 Jul 2020 23:40:31

RE: Slicer mandatory selection property

yes please! I need this to select the max(date) or Lastdate(date) or something like this. We want to show what's current, but allow viewing the past.

's profile image Profile Picture

Power BI User on 05 Jul 2020 23:37:03

RE: Slicer mandatory selection property

A very important feature. Please implement. Chiclet Slicer in the market place has it but that one lacks the drop-down option.

's profile image Profile Picture

andreucci on 05 Jul 2020 23:35:45

RE: Slicer mandatory selection property

this would let us build beautiful interface for text only reports, instead of forcing us writing a crazy amount of DAX formulas.

please add this asap!