We have a document library in SharePoint 2013 on-premise with nearly 12k items(List View threshold limit was set to 50k items). There is a column with the name Cust Name(Indexed Column) of type Single Line of Text.

Filter Choices not showing for the Column.

enter image description here

The filters are working fine for the other single line of text columns(Indexed columns).

Can anyone help me on this?

1 Answer 1


By default, if there are more than 500 unique values in a column, the column header filtering will display “Show Filter Choices” instead of the unique values in the column to avoid performance issues.

More references:

"Show filter choices" link instead of actual values in a list column filter


  • Thanks for the solution. Will check and update
    – TARUN
    Commented Jan 24, 2020 at 4:49

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.