Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Vote for your favorite vizzies from the Power BI Dataviz World Championship submissions. Vote now!

Reply
RGI
Helper III
Helper III

Chiclet slicer very slow when searching - are there other options?

I need to force my users to select one store from around 600.

The Chiclet slicer is ideal for my needs except that it's really slow on some of my older Windows 8.1 tablets

 

Once a store is selected it's fine, but due to the large number of stores we need to enable search. It's the search that's very slow. One waits up to 30 seconds between each letter you type in. Pretty much unusable.

 

Are there other options that force the user to select one item in a slicer?

Is there a way to speed up the Chiclet slicer?

 

2 REPLIES 2
v-frfei-msft
Community Support
Community Support

Hi @RGI,

 

Currently, it is not possible to force user to select one value in Chiclet slicer. You can come up a new idea about this. what's more, you can refer to this blog to improve usability and performance.

 

Regards,

Frank

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the others find it more quickly.

Hi @v-frfei-msft

 

You can force the user to select one item in the Chiclet slicer. So from that pov it works according to my needs.

However, the issue is that it's really slow when searching in the slicer.

 

Thanks for the link to the blog. We already employ the suggestions that affect perfomance.

 

You may have got confused between the standard Microsoft slicer (which doesn't force a user to select one entity) and the Chiclet slicer (which can force the user to select one entity).

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

Vote for your favorite vizzies from the Power BI World Championship submissions!

Sticker Challenge 2026 Carousel

Join our Community Sticker Challenge 2026

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

January Power BI Update Carousel

Power BI Monthly Update - January 2026

Check out the January 2026 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.