Skip to main content

PivotGridOptionsChartDataSourceBase.DataProvideMode Property

Gets or sets what data the pivot grid should pass to a bound chart control.

Namespace: DevExpress.XtraPivotGrid.Data

Assembly: DevExpress.PivotGrid.v24.1.Core.dll

NuGet Packages: DevExpress.PivotGrid.Core, DevExpress.Win.Navigation

Declaration

[XtraSerializableProperty]
public virtual PivotChartDataProvideMode DataProvideMode { get; set; }

Property Value

Type Description
PivotChartDataProvideMode

A PivotChartDataProvideMode enumeration member that specifies what data the pivot grid should pass to a bound chart control.

Available values:

Name Description
ProvideLastLevelData

PivotGrid passes only values from the lowest detail level.

UseCustomSettings

PivotGrid determines which values to provide based on the PivotGridOptionsChartDataSourceBase.Provide…Totals property values.

Remarks

When displaying pivot grid data in a chart, you rarely need to compare cell values to Totals or Grand Totals as these values differ significantly. At the same time, when selecting large cell blocks, Total values inevitably appear within the selection.

Use the DataProvideMode property to solve this. When this property is set to PivotChartDataProvideMode.ProvideLastLevelData, the pivot grid automatically defines which values should be passed to ChartControl. It analyzes the current selection, finds the lowest-level data and excludes all higher-level Totals.

The following animation shows how selection changes are reflected within a bound Chart control.

DataProvideMode

Note that this feature works only if field values are passed to the chart as text. By default, numeric or date-time values are not cast to text and passed to the chart “as is”. To force the pivot grid to cast them to strings, set the PivotGridOptionsChartDataSourceBase.FieldValuesProvideMode property to PivotChartFieldValuesProvideMode.DisplayText.

With specific selections, the PivotGridControl is unable to define which values have the lowest level. To specify the pivot grid behavior in such cases, use the PivotGridOptionsChartDataSourceBase.DataProvidePriority property. To learn more, see PivotGridOptionsChartDataSourceBase.DataProvidePriority.

See Also