Skip to main content

Power BI

Needs Votes

Slicer mandatory selection property

Vote (443) 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

Mark on 05 Jul 2020 22:38:25

RE: Slicer mandatory selection property

Absolutely needed!

's profile image Profile Picture

Buminda on 05 Jul 2020 22:34:27

RE: Slicer mandatory selection property

Yes, most of the time duplicate data will be presented and the end user is totally confused if this selection is not set mandatory.Also when opening the report I need to set one of them selected by default.

's profile image Profile Picture

phillip786 on 05 Jul 2020 22:29:24

RE: Slicer mandatory selection property

Yes this is needed in the case where you have data that if not filtered doesn't present usable data

's profile image Profile Picture

Scott Edgerton on 05 Jul 2020 22:29:11

RE: Slicer mandatory selection property

This is almost a requirement for some of the work that i have been doing relating to Sales Executive Dashboards, I want to look at just one Sales Exec at a time, it makes no sense to see all the information for all opportunities on a page specifically designed for an individual break down.

's profile image Profile Picture

WVanpeel on 05 Jul 2020 22:27:22

RE: Slicer mandatory selection property

Again, its unbelievable this is not available. Also when you de-select 'Select All' the system should not retrieve any data at all.

's profile image Profile Picture

Power BI User on 05 Jul 2020 22:25:42

RE: Slicer mandatory selection property

I am currently assessing Power BI as an alternative to an interactive excel worksheet but not having this option has limited the applications usefulness.

's profile image Profile Picture

Itay Rom on 05 Jul 2020 22:20:59

RE: Slicer mandatory selection property

I actually wrote a custom slicer visual that's doing just that(Selection is mandatory and if one is not present, a default selection will be made), but the recently-enabled sandboxing feature wreaked havoc upon it and rendered it useless(beyond repair). Therefore, I truly hope this idea would be implemented.

's profile image Profile Picture

Daniel Otykier on 05 Jul 2020 22:20:58

RE: Slicer mandatory selection property

Should be quite simple to add this to the "Selection Controls" section of the format properties.

's profile image Profile Picture

Jake on 05 Jul 2020 22:14:56

RE: Slicer mandatory selection property

Exactly what I am looking for!

's profile image Profile Picture

Niall on 05 Jul 2020 22:14:56

RE: Slicer mandatory selection property

YES