SharePoint List Filter Problems (or "Show Filter Choices")

When a SharePoint List gets to a certain size, around 500 items, some fields will no longer display a proper drop down for filter choices (e.g. single line of text columns). Instead, it will display “Show Filter Choices”. Microsoft did this to prevent performance problems by showing >500 options to choose from.

If you are receiving a rendering error after selecting Show Filter Choices, be sure to install the June 2009 or newer CU.

Trevor Seward is a Microsoft Office Apps and Services MVP who specializes in SharePoint Server administration, hybrid scenarios, and SharePoint Online. He has been working with SharePoint for 16 years from SharePoint 2003 on up, managing environments with terabytes of content for 150,000+ user organizations. Trevor is an author of Deploying SharePoint 2016 and Deploying SharePoint 2019. You can find him on Twitter and in /r/sharepoint.