Forum Discussion

rpinxt's avatar
rpinxt
Solution Sage
2 years ago

Custom Slicers

Do you guys know if there are custom slicers in which you can set the maximum choices a user can make?   For instance when you have a slicer with 6 option set the max selectable options to 2 or 3. ...
Need Help
Alex87's avatar
Alex87
Solution Sage
2 years ago

Hello,

You can create a measure that checks the number of selected items in a slicer and uses this to display a message or control other aspects of your report dynamically. This won't prevent more selections but can alert users or influence other report elements based on the number of selections.

DAX
Selected Count = COUNTROWS(VALUES('Table'[Column]))

  • rpinxt's avatar
    rpinxt
    Solution Sage
    2 years ago

    Thanks Alex87 I read about the dax way.

     

    But still was wondering if there is also a real solution where a slicer has a maximum selection.