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

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!