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

5 Replies

  • BITomS's avatar
    BITomS
    Solution Supplier
    4 months ago

    Hi Biswajit_Hitu ,

     

    It's not possible to combine multi-select with force selection (although force selection on it's own is possible if you turn Single Select to On).

     

    But there may be a workaround if you create a visual level filter:

     

    SlicerSelectionStatus = IF( ISFILTERED('YourTable'[SlicerColumn]), 1, 0 )

     

    If you set this to 1 in your "Filters on this visual" pane, if nothing is selected, the visual will not show anything i.e. if nothing is selected, it will effectively force a user to select at least one option.

     

    Hope this helps! 

  • 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

  • cengizhanarslan's avatar
    cengizhanarslan
    Super User
    4 months ago

    There is no native "mandatory selection" enforcement in Power BI slicers, a user can always deselect all values, and there is no built-in setting to prevent this.

     

    Option 1) Default to all values when nothing is selected

    Wrap your measures so that if nothing is selected, they behave as if everything is selected:

    Sales (Protected) =
IF (
    ISFILTERED ( 'DimTable'[Column] ),
    [Sales],
    CALCULATE ( [Sales], ALL ( 'DimTable'[Column] ) )
)

     

    Option 2) Show a warning message when nothing is selected

    Selection Warning =
IF (
    NOT ISFILTERED ( 'DimTable'[Column] ),
    "⚠ Please select at least one value",
    BLANK ()
)

    Add a Card visual with this measure, it appears only when the slicer is empty, prompting the user to make a selection.

  • v-prasare's avatar
    v-prasare
    Community Support
    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.


    cengizhanarslan, govind_021 & BITomS ,Thanks for your prompt response

     

     

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

  • v-prasare's avatar
    v-prasare
    Community Support
    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