Create a Filter for Critical Milestones in Microsoft Project

In this guide, I’ll show you how to create a Filter for Critical Milestones in Microsoft Project. While Microsoft Project offers a filter for critical tasks and milestone tasks individually, it doesn’t provide a built-in filter for critical milestones – those milestones which are on the Critical Path. So, let’s dive into how to create this custom filter.

Companion Articles in This Views, Tables, Filters & Formatting Series: Explore these connected tutorials in the same topic area to build your skills step by step:

Create a Filter for Critical Milestones in Microsoft Project

YouTubeWatch the Step-by-Step Video

Prefer to follow along visually? This video demonstrates the exact steps you’ll learn below using Microsoft Project Desktop.

At a Glance: Create a Filter for Critical Milestones in Microsoft Project:

  • Applies to: Microsoft Project Standard and Professional (2016, 2019, 2021, 2024, and subscription editions).
  • Key Step / Takeaway 1: Creating a Custom Filter for Critical Milestones
  • Key Step / Takeaway 2: Testing Your New Custom Filter
  • Best Practice: Follow the numbered step-by-step instructions below to apply this technique cleanly in your schedule.

What Are Critical Milestones?

Before we begin, let’s define what we’re targeting. Critical milestones are key project events or tasks that are both milestones and on the Critical Path. In other words, they’re the tasks that CANNOT be delayed without impacting your project’s Finish date.

Creating a Custom Filter for Critical Milestones

  1. Click the View tab to open the View ribbon.
  2. Click the “Filter” pick list button and choose “New Filter” from the options.
  3. In the Filter Definition dialog, enter a name for the custom filter. I recommend naming it “_Critical Milestones” (the underscore character pushes it to the top of your filter list alphabetically).
  4. In the Filter Definition dialog, create a two-row filter using the following criteria:
  • Milestone Equals Yes
  • Critical Equals Yes
  1. In the Filter Definition dialog, select the “Show related summary rows” checkbox to include summary tasks for each identified milestone.
  2. Click the “Save” button to save your new filter.

Testing Your New Custom Filter

Complete the following steps to test your new custom _Critical Milestones filter:

  1. In the View ribbon, click the “Filter” pick list button again.
  2. Your new filter should appear at the top of the list in the Custom section. Select your custom filter to apply it.
  3. You should now see only the critical milestones in your project.

Conclusion

And there you have it! You’ve successfully created a custom filter that displays only critical milestones in Microsoft Project. This is a handy tool for quickly identifying key tasks that are both milestones and on the Critical Path.

If you have questions, please add them in the “Leave a Reply” section below. Or if you watched the video, add your questions or comments there. Please subscribe to my YouTube channel and leave “Likes” if you like the videos.

If you would like to have a formal class on using Microsoft Project, here is a link for my classes.

Leave a Reply

Your email address will not be published. Required fields are marked *

Are you human? Please solve:Captcha


Table of Contents

Add a header to begin generating the table of contents

Need Microsoft Project Training?

Microsoft Desktop Training $399 with Dale Howard MVP

Project Server Training

Project Server Training with Dale Howard MVP

1-on-1 Training

Get 1-on-1 Private Training with Dale Howard MVP