How can we improve Power BI?

Slicer mandatory selection property

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.

352 votes
Sign in
(thinking…)
Sign in with: facebook google
Signed in as (Sign out)

We’ll send you updates on this idea

Anonymous shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

48 comments

Sign in
(thinking…)
Sign in with: facebook google
Signed in as (Sign out)
Submitting...
  • Alex Miles commented  ·   ·  Flag as inappropriate

    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.

  • Dz commented  ·   ·  Flag as inappropriate

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

  • Vicky M commented  ·   ·  Flag as inappropriate

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

  • Rhonda Smart commented  ·   ·  Flag as inappropriate

    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.

  • Anonymous commented  ·   ·  Flag as inappropriate

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

  • andreucci commented  ·   ·  Flag as inappropriate

    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!

  • Anonymous commented  ·   ·  Flag as inappropriate

    This would be an extremely useful feature for large data sets, or visuals that are meant to be comparative between categories, but with many categories to select from.

  • Dan English commented  ·   ·  Flag as inappropriate

    If we could simply incorporate the Forced Selection option like the Chiclet Slicer has that would be wonderful.

  • Divya commented  ·   ·  Flag as inappropriate

    Please add this option in slicer, this is a necessity with huge datasets

  • Johnny commented  ·   ·  Flag as inappropriate

    Please add this feature as soon as possible. When dealing with huge datasets, end-user experience may be ruined by deselecting all filters.

  • Omri Saadi commented  ·   ·  Flag as inappropriate

    Without this feature, many reports and dashboards may be "broken" by user deselecting options to view "All". This must be remedied soon. Simply add a toggle to say "Mandatory Select" and many users will see immense value with it.

  • Shilpa commented  ·   ·  Flag as inappropriate

    Please add this function. In some circumstances, the data doesn't make sense (at all) when there is no selection.

← Previous 1 3

Feedback and Knowledge Base

Ready to get started?

Try new features of Power BI today by signing up and learn more about our powerful suite of apps.