Forum Discussion

Umadhandapani's avatar
Umadhandapani
Icon for Helper II rankHelper II
4 years ago
Solved

Only two slicer selection at a time

Hi, I have the scenario to choose the slicer not more than two selection at a time. Is this possible? In what way?
Need Help
  • Fowmy's avatar
    Fowmy
    4 years ago

    Umadhandapani 

    You can create a measure to show a text, sort of warning when users select more than 2 items from the slicer. This is the measure:

    SelectionLimit = 
IF(
     ISCROSSFILTERED(financials[Product]) && COUNTROWS( VALUES( financials[Product] ) ) > 2 ,
     "Maximum 2 items",
     ""
)

     



jaipal's avatar
jaipal
Icon for Resolver III rankResolver III
4 years ago

Umadhandapani  as far as I know either you can set to single selection or multi selection. I don't think there is an option to set selection limit. 

 

FYI: I hope you already know you can multi select by holding "ctrl"

Umadhandapani's avatar
Umadhandapani
Icon for Helper II rankHelper II
4 years ago

Is there any other visual to use the concept?
Or using any measures?