allowing only single selection in slicers


  • Hi Team,

    I am creating a dashboard in excel 2010. There is a slicer which selects products but it should always allow only one selection.

    Is it possible to throw an exception or doesn't allow to do a multiple selection in excel slicer without any VBA code?



    Wednesday, September 05, 2012 4:14 AM


All replies

  • You can't avoid the multi selction but you can write something like that in your mesure:

    =IF( COUNTROWS( VALUES( Product[ProductId] ) ) = 1,YourMeasure,"ONLY ONE PRODUCT PLEASE")

    Thursday, September 06, 2012 11:57 AM
  • Thanks.

    Where should i write this condition? i have throw an exception when user does multiple selection of products



    Thursday, September 06, 2012 12:11 PM
  • Eshwar,

    Is this still an issue?


    Ed Price, SQL Server Customer Program Manager (Blog, Small Basic, Wiki Ninjas, Wiki)

    Answer an interesting question? Create a wiki article about it!

    Monday, October 28, 2013 5:29 AM
  • Hello there,

    This is exactly what I need but I cannot figure out where this code will go. Please guide where ti incorporate this code. We are on Excel 2010.

    Thanks a lot

    Naseer - Houston

    Wednesday, February 12, 2014 12:08 AM