Skip to main content

    Power BI

    Needs Votes

    Slicer mandatory selection property

    Vote (387) 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 (48)
    's profile image Profile Picture

    1a30bdda 1fbb-4448-b67e-00a7e96bcf47 on 05 Jul 2020 22:46:53

    RE: Slicer mandatory selection property

    This is a must

    's profile image Profile Picture

    6a93ce82 385b-4ca5-b9a3-f56cc920023d on 05 Jul 2020 22:46:45

    RE: Slicer mandatory selection property

    Yes, it is.

    's profile image Profile Picture

    04ad421c 55a0-4729-9876-fc9ae8ebe4c3 on 05 Jul 2020 22:45:33

    RE: Slicer mandatory selection property

    This is just a basic "radio button" approach. It would be perfect for reports letting the user choose between different currencies etc.

    's profile image Profile Picture

    0297246f 3b9a-4263-b045-29915d4066c7 on 05 Jul 2020 22:45:31

    RE: Slicer mandatory selection property

    I would greatly appreciate this feature. Thank you!

    's profile image Profile Picture

    10357d14 5333-4d32-9f23-a88ed62f173a on 05 Jul 2020 22:44:29

    RE: Slicer mandatory selection property

    This is also needed when summarizing on an entire dataset would be an improper use of the data.

    's profile image Profile Picture

    daacd3c9 ea90-48e1-a3f9-96d32b1357a6 on 05 Jul 2020 22:42:27

    RE: Slicer mandatory selection property

    Core function, very much needed!!!

    's profile image Profile Picture

    5fec3b7d e439-4b3e-bdef-7f7b13c25c73 on 05 Jul 2020 22:38:49

    RE: Slicer mandatory selection property

    Yes this will help, enforce database filtering and avoid querying all the data... and crash the report..

    's profile image Profile Picture

    08484e38 4ebf-4764-b861-7f82155a53d1 on 05 Jul 2020 22:38:31

    RE: Slicer mandatory selection property

    Must to have urgently please !

    's profile image Profile Picture

    8ff243e9 a925-427b-b336-f99f23260ee0 on 05 Jul 2020 22:38:25

    RE: Slicer mandatory selection property

    Absolutely needed!

    's profile image Profile Picture

    6ca48c42 fad3-48ad-92f2-c9256ba30f84 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.