1. Modeling
  2. Working with Data
  3. Quick Filter
  4. Quick Filter and large data sets

A Quick Filter only shows unique items for the first 100,000 cells that are displayed in the grid. If the number of data items exceeds this limit, this message may display when you create a Quick Filter:

If this message displays and you need to filter your data on an item that is not listed in the dropdown, you can reduce the number of displayed items by:

Note: If your model contains a large amount of data, the items might take several seconds to display.