Forum Discussion
Umadhandapani
Helper II
Helper IIOnly 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?
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", "" )
Fowmy
Super User
Super UserUmadhandapani
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",
""
)