SharePoint Document Issues

Fix SharePoint List Filter Not Showing All Values

Camila Milosovich Oct 7, 2026 870 views

Question details

Users are experiencing an issue where SharePoint or Microsoft List filters only display a partial list of values for Text or Choice columns.

How to Fix SharePoint List Filter Not Showing All Values

Product: SharePoint
Device & OS: not provided
Scenario: Filtering data within a SharePoint or Microsoft List to locate specific entries.
Observed behavior: The filter dropdown is missing several choice or text values, making it impossible to accurately filter list items.

Before you start

Ensure you have the necessary permissions to view all items in the SharePoint list and verify that the missing values actually exist in the list's dataset.

Solution 1Recommended

Troubleshoot Browser Cache with InPrivate Mode

Often, missing filter values are caused by a stale browser cache. Testing in InPrivate mode helps isolate and resolve the issue.

Browser caching can sometimes cause SharePoint lists to load outdated or incomplete data in the filter dropdown. By using an Incognito or InPrivate window, you bypass the cached data to load the most recent list information.

Open an InPrivate window

Launch your web browser and open a new InPrivate or Incognito window (usually accessed via the browser menu or by pressing Ctrl+Shift+N / Ctrl+Shift+P).

Access the SharePoint list

Test the filter

Click the filter icon on the affected Text or Choice column. If all values appear correctly, return to your normal browser window and clear your browsing data and cache.

Troubleshoot Browser Cache with InPrivate Mode

Cache Cleared: Clearing your browser cache regularly can prevent similar display issues in SharePoint and Microsoft Lists.

Solution 2

Verify List Permissions and User Accounts

Filter values might be hidden if your account lacks permission to view certain items containing those values.

Solution 3

Report Persistent Issues to Microsoft

If the issue affects multiple users, accounts, and browsers, it may be a backend service disruption that requires Microsoft Support.

Free Microsoft Office alternative

Looking for a smoother office experience? Try WPS Office

While SharePoint is designed for complex enterprise databases, tracking simple lists and tables can sometimes be frustrating due to caching and syncing issues. If you need a hassle-free, offline-capable way to manage and filter your team's data, WPS Spreadsheet is a fast, highly compatible alternative.

1. Download and Install: Visit the official WPS website to download the free WPS Office installer and follow the on-screen prompts.
2. Open WPS Spreadsheet: Launch WPS Office and open a new or existing spreadsheet to start managing your data.
3. Apply Filters Easily: Highlight your table headers, navigate to the Data tab, and click Filter to instantly view and sort all your column values.

Completely free and lightweight suite for everyday data processing.Highly compatible with Microsoft Excel (.xlsx) formats for easy sharing.Built-in, easy-to-use filters that work instantly without server sync delays.Familiar user interface for a seamless transition from Microsoft Office.

microsoft office alternative - wps office

Frequently Asked Questions

Why are some Choice column values missing in my SharePoint filter?

This is often due to browser caching issues, lacking item-level permissions to view entries containing those values, or service-side glitches. Testing in an InPrivate window can help determine if it is a browser cache issue.

Can the SharePoint 5000 item limit affect list filters?

Yes, if a SharePoint list exceeds the 5000 item view threshold, filtering and sorting features may fail to display correctly or omit data unless the column is properly indexed.

How do I fix incorrect filter value order in Microsoft Lists?

For Choice columns, values typically follow the order defined in the column settings. You can navigate to List Settings > Columns, select the affected column, and rearrange the choices manually.

Document & File Issues