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

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.