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  I am not sure about DAX measure, but you can use the custom visual to control the selection limit