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",
     ""
)

     



4 Replies

  • Fowmy's avatar
    Fowmy
    Icon for Super User rankSuper User
    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?

  • 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