force user to select slicer

[MP_123]

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!

[Anonymous]

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.

[Anonymous]

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.

---

[mjmmet]

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!

[v-haibl-msft]

@MP_123

You can vote this idea in below two links.

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/11509449-slicer-mandatory-selecti...

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/7162004-default-selected-slicer-o...

Best Regards,

Herbert

[itayrom]

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]

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

[itayrom]

That is correct.