cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Reh
Frequent Visitor

ChicletSlicer maximum rows issue

Hi all, 

 

Chicletslicer caps out at 1,000 rows (either scrolling or searching past row 1K in the data). Not sure if that is by design. I need to utilize multi select, single select, force features that are not available in the native slicer. ChicletSlicer has these but it appears to be limited to first 1000 rows. Is it possible to extend that limit?


Thanks

1 ACCEPTED SOLUTION
v-juanli-msft
Community Support
Community Support

Hi @Reh

If you only need to utilize multi select, single select, you could use the default slicer, turn off "single select" under the "selection controls".

1.png

 

Best Regards

Maggie

View solution in original post

4 REPLIES 4
dheeraj10
Microsoft
Microsoft

Facing same issue. I have a column with more than 1000 distinct values in it. Cannot search values that fall beyond 1000 rows. Is there any way to remove the cap limit or any alternate solution with forced selection option present ?

 

v-juanli-msft
Community Support
Community Support

Hi @Reh

As tested, with the defauld slicer, i can select more than 1000 rows.

 

Best Regards

Maggie

v-juanli-msft
Community Support
Community Support

Hi @Reh

If you only need to utilize multi select, single select, you could use the default slicer, turn off "single select" under the "selection controls".

1.png

 

Best Regards

Maggie

Hi Maggie, 

Thanks! I did end up using the default slicer. However chiclet is a lot more dynamic and has some really cool features such as forced selection an picking the visible selections etc. But seems to cap out at 1000 rows. 

Regards

Helpful resources

Announcements
Carousel_PBI_Wave1

2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

Power BI Summit Carousel 2

Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

BizApps LATAM 2023

Business Application LATAM Summit 2023

Join the biggest FREE Business Applications Event in LATAM this February.

Power Platform Bootcamp

Global Power Platform Bootcamp

In this bootcamp we will deep-dive into Microsoft’s Power Platform stack with hands-on sessions and labs, delivered to you by experts and community leaders.