Others

How to Fix Microsoft Project Filters Not Working in Chart Views

Steve K Oct 21, 2026 868 views

Question details

Users are experiencing issues where Microsoft Project 2019 filters do not update chart or Project views after selecting values from column drop-downs.

How to Fix Microsoft Project Filters Not Working in Chart Views

Product: Microsoft Project 2019
Device & OS: not provided
Scenario: Filtering data in a chart view or Project view using column drop-downs.
Observed behavior: The chart or view does not update or reflect the selected filter criteria, leaving the display unchanged.

Before you start

Ensure you have the correct Project view open, such as the Gantt Chart, rather than a report chart, as filtering behaves differently across these views.

Solution 1Recommended

Disable Highlight Settings to Apply Filters

Sometimes the filter is set to highlight results rather than hide non-matching rows. Changing this setting resolves the issue and restores traditional filtering.

In Microsoft Project, you can choose to either filter out tasks that do not match your criteria or simply highlight the ones that do. If the Highlight function is active, drop-down filters will not hide data.

Navigate to the View Tab

Open your Microsoft Project file and click on the 'View' tab located in the main ribbon.

Locate Highlight Settings

Find the 'Data' group within the View ribbon and click on the 'Highlight' drop-down menu.

Select No Highlights

Choose 'No Highlights' from the list. This ensures your column filters will hide non-matching data instead of just highlighting matches.

Disable Highlight Settings to Apply Filters

Check Your Criteria: Confirm that the criteria you selected in the drop-down should actually return results within your current project data.

Solution 2

Test Filter Functionality in a Sample Project

Testing in a new or sample file helps determine if the filtering issue is isolated to your specific project file or a global application glitch.

Free Microsoft Office alternative

Manage Your Projects Effectively with WPS Office

While Microsoft Project is a dedicated tool, it can be complex and expensive. For many users, managing project timelines, tasks, and budgets is easily accomplished using Excel-compatible spreadsheets in WPS Office. It's lightweight, free, and highly compatible with standard Microsoft Office formats, making project tracking accessible to everyone.

1. Download and Install: Download WPS Office for free from the official website and install it on your device.
2. Open a Project Template: Launch WPS Spreadsheet and search for 'Gantt Chart' or 'Project Tracking' in the built-in template library.
3. Customize and Filter: Input your tasks and timelines. Use the intuitive drop-down filters to easily sort and manage your project data without complex database settings.

Create custom Gantt charts easily using rich spreadsheet templatesHighly compatible with Microsoft Excel (.xlsx) formats for seamless sharingLightweight, fast, and completely free to useFamiliar, easy-to-navigate user interface requires no steep learning curve

Frequently Asked Questions

Why do my column filters in Microsoft Project highlight tasks instead of hiding them?

This happens when a highlight filter is active instead of a standard filter. Go to the View tab, find the Highlight drop-down in the Data group, and select 'No Highlights' to restore normal filtering behavior.

Can a corrupted view cause filters to stop working in MS Project?

Yes, if the Gantt Chart or specific project view is corrupted, filters may fail to apply. You can try copying your tasks into a brand-new project file or resetting the view to default settings to fix this.

Do drop-down filters work in Microsoft Project report charts?

No, standard column drop-down filters apply specifically to Project views like the Gantt Chart or Task Sheet. To filter data in a report chart, you need to use the Field List pane that appears when the chart is selected.

Office Quick Solutions