PivotGridControl.FieldFilterPopupMode Property

Specifies the type of the filter drop-down invoked by clicking a filter button in the field header. This is a dependency property.

Namespace: DevExpress.Xpf.PivotGrid

Assembly: DevExpress.Xpf.PivotGrid.v19.2.dll

Declaration

C#

public FilterPopupMode FieldFilterPopupMode { get; set; }

VB.NET

Public Property FieldFilterPopupMode As FilterPopupMode

Property Value

Type	Description
FilterPopupMode	An enumeration member that specifies the type of the filter drop-down.

Available values:

Name	Description
Default	Default value
Legacy
Excel

Remarks

The Pivot Grid supports Excel-style and Classic pop-up filters. You can specify the pop-up filter style at three levels:

1. Application level

   Use the static CompatibilitySettings.UseLegacyColumnFilterPopup property for all controls in the application.

2. Control level

   Use the PivotGridControl.FieldFilterPopupMode property for PivotControl’s fields. This control level setting overrides the UseLegacyColumnFilterPopup global setting.

3. Field level

   Use the PivotGridField.FilterPopupMode property for a specific field. The field level setting overrides the control level settings.

See Pop-up Filter for more information.

You cannot use Excel-style filters in the following cases:

• the datasource type is OLAP;
• the PivotGridControl.CustomFilterPopupItems event is handled.

Related GitHub Examples

The following code snippets (auto-collected from DevExpress Examples) contain references to the FieldFilterPopupMode property.

Note

The algorithm used to collect these code examples remains a work in progress. Accordingly, the links and snippets below may produce inaccurate results. If you encounter an issue with code examples below, please use the feedback form on this page to report the issue.

C#

wpf-pivotgrid-customize-filter-editor/CS/WpfPivotCustomizeFilterEditorExample/WpfPivotCustomizeFilterEditorExample/MainWindow.xaml#L41

DataSource="{Binding Path=Data, Source={StaticResource ExcelItemsSource}}"
FieldFilterPopupMode="Excel"
Name="pivotGridControl1"

wpf-pivotgrid-customize-filter-drop-down/CS/WpfPivotCustomFilterDropDownExample/MainWindow.xaml#L44

Name="pivotGridControl1"
FieldFilterPopupMode="Excel"
ShowOnlyAvailableFilterItems="True">