Forum Discussion

Reh's avatar
Reh
Frequent Visitor
7 years ago
Solved

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

Need Help
Tips and Tricks
  • v-juanli-msft's avatar
    v-juanli-msft
    7 years ago

    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".

     

    Best Regards

    Maggie

4 Replies

  • v-juanli-msft's avatar
    v-juanli-msft
    Community Support
    7 years ago

    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".

     

    Best Regards

    Maggie

    • Reh's avatar
      Reh
      Frequent Visitor
      7 years ago

      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

  • v-juanli-msft's avatar
    v-juanli-msft
    Community Support
    7 years ago

    Hi Reh

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

     

    Best Regards

    Maggie

  • dheeraj10's avatar
    dheeraj10
    Microsoft Employee
    7 years ago

    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 ?