Skip to main content

PivotGridField.ShowNewValues Property

Gets or sets whether field values are shown in the datasource after field filtering is configured. This is a dependency property.

Namespace: DevExpress.Xpf.PivotGrid

Assembly: DevExpress.Xpf.PivotGrid.v22.1.dll

NuGet Package: DevExpress.Wpf.PivotGrid


public bool ShowNewValues { get; set; }

Property Value

Type Description

true to show new field values; otherwise, false.


If filtering applies to the current field, the ShowNewValues property specifies whether new field values (values that are added to the datasource after the filter condition is set) are shown or hidden by default.

If filtering is not applied to the field, new field values are always displayed, regardless of the ShowNewValues property value.

The ShowNewValues property is also not in effect if the current field is a part of a field group that uses a hierarchical filter (see PivotGridControl.GroupFilterMode). In this instance, use the group’s PivotGridGroup.ShowNewValues property.

The ShowNewValues property internally sets the filter type. The true value corresponds to the FieldFilterType.Excluded filter type, while the false value corresponds to the FieldFilterType.Included filter type.


The ShowNewValues property is not in effect when you set filter values in the Excel-style pop-up filter.

See Also