"Cannot show the value of the filter" error when you try to sort or filter a column in SharePoint Online

PROBLEM
When you click the drop-down arrow to sort or filter a column in the view in Microsoft SharePoint Online, you receive the following message:
Cannot show the value of the filter. The field may not be filterable, or the number of items returned exceeds the list view threshold enforced by the administrator.
SOLUTION
To resolve this issue, reduce the number of items in the view for the affected list or library to 5,000 items or less. To do this, take one of the following actions, as appropriate for your situation:
  • Create a new view for the list or library or change the existing view. When you do this, use indexed columns and filtering to keep the view size for the list to 5,000 items or less. For more information about how to create a filtered view that has a column index, go to the following Microsoft website: 
    Manage large lists and libraries in Office 365

    Note The list limit to add or remove an indexed column is 20,000 items.
  • Create folders in the library, and put items in the folders to keep the view for the library to 5,000 items or less.
MORE INFORMATION
This issue occurs when your list or library exceeds the list view threshold limit of 5,000 items for a view.

For more information, go to the following Microsoft website:

Still need help? Go to the Office 365 Community website.
Properties

Article ID: 3095371 - Last Review: 10/19/2015 22:24:00 - Revision: 3.0

Microsoft SharePoint Online

  • o365 o365e o365p o365a o365m o365022013 KB3095371
Feedback