Forum Discussion

MP_123's avatar
MP_123
Icon for Microsoft Employee rankMicrosoft Employee
10 years ago

force user to select slicer

hi, please see image.

currently the slicer is defined to 'single select only' but the problem is when you select on the selected option, the option is deselects, and then it's like ' select all' option.

hope it was clear, is it is possible to disable the deselect option?

 

thanks!

Need Help

7 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    Hie, go to https://app.powerbi.com/visuals/ and import ChicletSlicer. This visual makes user to select atleast one value. Go to Format and select Forced Selection option.

     

     

    Hope this helps. :smileyvery-happy:

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      Thank you Ambre! That totally worked!

      Anonymous wrote:

      Hie, go to https://app.powerbi.com/visuals/ and import ChicletSlicer. This visual makes user to select atleast one value. Go to Format and select Forced Selection option.

       

       

       

      Hope this helps. :smileyvery-happy:

       

      • mjmmet's avatar
        mjmmet
        Frequent Visitor
        7 years ago

        I need to force a single selection for Year in my report and was so excited about the Chiclet slicer being able to do this.  But, I have found a couple of issues. 

         

        • If you set Multiple selection Off you can still selected multiple values in the slicer using Ctrl key
        • Also, you cannot Sync the slicer across the pages

        Please let me know if there is a way around these issues using the Chiclet slicer or if I am misunderstanding how it is supposed to work. 

         

        Thanks!

  • itayrom's avatar
    itayrom
    Icon for Resolver II rankResolver II
    10 years ago

    Unfortunately, this option does not currently exist in Power BI. I saw several people posted ideas regarding this issue, so lets hope the visuals dev team is working on it.

     

    In the meantime, you have two options I know of -

    1. Implement a custom slicer visual with this behavior.

    2. Use DAX expressions to prevent data from being displayed(and maybe show an appropriate message in a card visual, for example) when there isn't exactly one selection present in the slicer.

     

    I experimented with both options, and while the second one works, it makes large reports work significantly slower in Power BI Service. The first option seems to work much better, but requires you to address several issues caused by the custom visuals sandboxing feature, such as automatically making an initial selection after the visual finished loading, because filters in sandboxed visuals are not saved when saving a report, etc...

    • MP_123's avatar
      MP_123
      Icon for Microsoft Employee rankMicrosoft Employee
      10 years ago

      thanks! what do you mean by implementing? to write my own visual?