WPF DataGrid Filter - Excel like Filter

Excel-inspired check list box filter UI

An Excel-inspired filter UI filters records. The filter UI contains a check list box for selecting items so users can filter records easily.

Advanced Excel-inspired filter UI

Users can filter data easily by using multiple options provided in the filter UI. Built-in filter types:

• Text filters
• Number filters
• Date filters using date picker

Text filter

Text filter menu options are loaded when the column’s underlying property is string or dynamic. The following options are available:

• Equals
• Does Not Equal
• Begins With
• Ends With
• Contains
• Does Not Contain
• Empty
• Not Empty
• Null
• Not Null

Number filter

When the column’s underlying property is integer, double, short, decimal, byte, or long, number filter menu options are loaded. The following number filter options are available:

• Equals
• Does Not Equal
• Null
• Not Null
• Less Than
• Less Than or Equal
• Greater Than
• Greater Than or Equal

Date filter

Load various date filter options when the column’s underlying property is date-time. The date-time can be selected intuitively by using a date picker. The following date filter options are available:

• Equals
• Does Not Equal
• Before
• Before or Equal
• After
• After or Equal
• Null
• Not Null

Instant filtering

You can allow users to update the filters immediately whenever updating the filter UI pop-up.

Filter row

The WPF DataGrid control provides a built-in row called a filter row to filter the individual column values. Editors for the filter row can be loaded based on the underlying column property type to filter data easily. Built-in editors:

• TextBox
• Numeric
• ComboBox
• Multiselect ComboBox
• CheckBox
• DateTime

Filter row documentation