PivotGridField.CustomExcelStyleFilterPopupTemplate Property

Gets or sets a template used to display the Excel-style filter drop-down for the current field. This is a dependency property.

Namespace: DevExpress.Xpf.PivotGrid

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

NuGet Packages: DevExpress.WindowsDesktop.Wpf.PivotGrid, DevExpress.Wpf.PivotGrid

Declaration

C#

public DataTemplate CustomExcelStyleFilterPopupTemplate { get; set; }

VB.NET

Public Property CustomExcelStyleFilterPopupTemplate As DataTemplate

Property Value

Type	Description
DataTemplate	A DataTemplate object displayed as the filter drop-down.

Example

The following code snippet uses the CalendarFilterElement to filter the Order Date field values:

Xaml

<dxpg:PivotGridField
    Area="FilterArea"
    Caption="OrderDate"
    FieldName="OrderDate"
    GroupInterval="Date"
    Name="fieldOrderDate"
    ImmediateUpdateExcelStyleFilter="False">
    <dxpg:PivotGridField.CustomExcelStyleFilterPopupTemplate>
        <DataTemplate>
            <dxfui:CalendarFilterElement Name="PART_FilterElement" />
        </DataTemplate>
    </dxpg:PivotGridField.CustomExcelStyleFilterPopupTemplate>
</dxpg:PivotGridField>

The image below shows the result:

Note

The complete sample project How to Create a Custom Filter Drop-Down is available in the DevExpress Examples repository.

Related GitHub Examples

The following code snippet (auto-collected from DevExpress Examples) contains a reference to the CustomExcelStyleFilterPopupTemplate 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.

XAML

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

ImmediateUpdateExcelStyleFilter="False">
<dxpg:PivotGridField.CustomExcelStyleFilterPopupTemplate>
    <DataTemplate>