I have a list which have a lot of data. I can filter list in standard view but when I use quick edit view, just some column can filtered. It's not display "show filter choice" when the column have too many choice. How can I fix that?

enter image description here

  • how many items do you have in your list and can you please let us know the type of column you are facing issues with
    – Sagar
    Jan 22, 2018 at 10:08
  • the list has about 10000 items but I filtered items to the view with 2000 items and it still can not filter. Many column has this issue, text, date, choice, ... I realize which column has a little data will display filter choice but if it has too much data then it will not display "show filter choice" like standard view do. Jan 22, 2018 at 10:31

2 Answers 2


This post deals with a similar kind of issue, it described a limitation of 5000 items in a view.

Read up on Indexing a column, this may help Sharepoint to permit filtering on your column.


I can't comment yet, so I have to add an answer.

But basically I want to follow up on what Tally said, and say that I've found strange behaviour like this before, and what fixed it for me (apart from indexing) was that the filtering had to be in a particular order. (the indexed filter first)

For instance - if I filtered first by "column A is not empty" then "indexed column > date", it would sometimes have symptoms like you described, but if I filtered first by "indexed column > date" then "column A is not empty", it would be happy.

My guess is that because "column A is not empty" filters down to still over threshold, before the indexed filter takes to under threshold, it bugs out.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.