Forum Discussion

Biswajit_Hitu's avatar
Biswajit_Hitu
Regular Visitor
4 months ago
Solved

Mandatory multi select slicer

Hello Team, Can we have a Slicer with multiple selection option and mandatory at least one value is selected
Need Help
  • v-prasare's avatar
    v-prasare
    4 months ago

    Hi @Biswajit_Hitu,

    We would like to confirm if our community members answer resolves your query or if you need further help. If you still have any questions or need more support, please feel free to let us know. We are happy to help you.

     

     

    Thank you for your patience and look forward to hearing from you.
    Best Regards,
    Prashanth Are
    MS Fabric community support

govind_021's avatar
govind_021
Super User
4 months ago

This is a common requirement in Power BI, but unfortunately there’s no built-in option to make a slicer mandatory. However, you can handle it with a simple workaround. First, set a default value in the slicer so that at least one option is always selected when the report loads. Next, disable the “Select All” option to reduce the chances of users clearing all selections. To enforce it further, you can create a DAX measure like

Selection Check = IF(ISFILTERED('Table'[Column]), 1, 0)

 and use it to control visuals or display a message (e.g., “Please select at least one value”) when nothing is selected. A more practical UX approach is to overlay a transparent shape with a message, which effectively blocks the report until the user makes a selection.
Best Regards
Govind Sapkade ( Microsoft Certified Data Analyst , PL 300 Certified , MS Fabric Enthusiast)
Let's Connect
Linkdin - www.linkedin.com/in/govind-sapkade-845104225
Youtube - http://www.youtube.com/@govind_dataanalyst