cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Reh Frequent Visitor
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

Accepted Solutions
Community Support Team
Community Support Team

Re: ChicletSlicer maximum rows issue

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
Community Support Team
Community Support Team

Re: ChicletSlicer maximum rows issue

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

Community Support Team
Community Support Team

Re: ChicletSlicer maximum rows issue

Hi @Reh

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

 

Best Regards

Maggie

Highlighted
Reh Frequent Visitor
Frequent Visitor

Re: ChicletSlicer maximum rows issue

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

dheeraj10 Frequent Visitor
Frequent Visitor

Re: ChicletSlicer maximum rows issue

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 ?

 

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 112 members 1,783 guests
Please welcome our newest community members: