SeriesBase.FilterCriteria Property

Gets or sets the current filter criteria.

Namespace: DevExpress.XtraCharts

Assembly: DevExpress.XtraCharts.v20.1.dll

NuGet Packages: DevExpress.Charts, DevExpress.WindowsDesktop.Charts

Declaration

C#

[XtraChartsLocalizableCategory(XtraChartsCategory.Data)]
public CriteriaOperator FilterCriteria { get; set; }

VB.NET

<XtraChartsLocalizableCategory(XtraChartsCategory.Data)>
Public Property FilterCriteria As CriteriaOperator

Property Value

Type	Description
CriteriaOperator	The current filter criteria.

Remarks

Use the FilterCriteria property to create a filter expression that consists of multiple conditions applied to multiple data columns, and apply it to the series’ data. Setting the FilterCriteria property to a new value clears any filters that have been previously applied.

Note that the FilterCriteria and SeriesBase.FilterString properties are dependent. If you update one of them, the other changes as well.

Use a CriteriaOperator descendants to specify the FilterCriteria property. Refer to Criteria Operators for more information.

C#

Series series = chartControl1.Series[0];
series.FilterCriteria = new BinaryOperator("CategoryID", 1, BinaryOperatorType.Equal) |
                        new BinaryOperator("CategoryID", 3, BinaryOperatorType.Equal) |
                        new BinaryOperator("CategoryID", 7, BinaryOperatorType.Equal);

VB.NET

Dim series As Series = chartControl1.Series(0)
series.FilterCriteria = New BinaryOperator("CategoryID", 1, BinaryOperatorType.Equal) Or 
                        New BinaryOperator("CategoryID", 3, BinaryOperatorType.Equal) Or 
                        New BinaryOperator("CategoryID", 7, BinaryOperatorType.Equal)

Alternatively, you can use the SeriesBase.FilterString property to pass a filter expression. Refer to Criteria Language Syntax for more information.

C#

Series series = chartControl1.Series[0];
series.FilterString = "CategoryID = 1 Or CategoryID = 3 Or CategoryID = 7";

VB.NET

Dim series As Series = chartControl1.Series(0)
series.FilterString = "CategoryID = 1 Or CategoryID = 3 Or CategoryID = 7"

You can also use the CriteriaOperator.Parse method to convert a filter string to its CriteriaOperator equivalent as follows:

C#

Series series = chartControl1.Series[0];
series.FilterCriteria = CriteriaOperator.Parse("CategoryID = 1 Or CategoryID = 3 Or CategoryID = 7");

VB.NET

Dim series As Series = chartControl1.Series(0)
series.FilterCriteria = CriteriaOperator.Parse("CategoryID = 1 Or CategoryID = 3 Or CategoryID = 7")

Example

To filter a data series using a criteria that FilterControl provides, assign the FilterControl.FilterCriteria property value to the SeriesBase.FilterCriteria property.

Note

A complete sample project is available at https://github.com/DevExpress-Examples/how-to-filter-points-in-a-chartcontrol-series-by-using-filtercontrol-e2340

Form1.cs

private void Form1_Load(object sender, EventArgs e) {
    filterControl.SourceControl = Products;
    filterControl.FilterString = "Contains([CategoryName], 'Condiments')";

    ProductSeries.DataSource = Products;
    ProductSeries.ArgumentDataMember = "ProductName";
    ProductSeries.ValueDataMembers.AddRange("UnitPrice");
    ProductSeries.FilterCriteria = filterControl.FilterCriteria;
}

private void filterControl1_FilterChanged(object sender, DevExpress.XtraEditors.FilterChangedEventArgs e) {
    // Because of Filter Control recreates its FilterCriteria, 
    // the criteria should be reassigned to the SeriesBase.FilterCriteria property.
    ProductSeries.FilterCriteria = filterControl.FilterCriteria;
}

Form1.vb

Private Sub Form1_Load(ByVal sender As Object, ByVal e As EventArgs) Handles Me.Load
    filterControl.SourceControl = Products
    filterControl.FilterString = "Contains([CategoryName], 'Condiments')"

    ProductSeries.DataSource = Products
    ProductSeries.ArgumentDataMember = "ProductName"
    ProductSeries.ValueDataMembers.AddRange("UnitPrice")
    ProductSeries.FilterCriteria = filterControl.FilterCriteria
End Sub

Private Sub filterControl1_FilterChanged(ByVal sender As Object, ByVal e As DevExpress.XtraEditors.FilterChangedEventArgs) Handles filterControl.FilterChanged
    ' Because of Filter Control recreates its FilterCriteria, 
    ' the criteria should be reassigned to the SeriesBase.FilterCriteria property.
    ProductSeries.FilterCriteria = filterControl.FilterCriteria
End Sub

Related GitHub Examples

The following code snippets (auto-collected from DevExpress Examples) contain references to the FilterCriteria 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#

how-to-filter-points-in-a-chartcontrol-series-by-using-filtercontrol-e2340/CS/FilterCriteriaSample/Form1.cs#L39

    ProductSeries.ValueDataMembers.AddRange("UnitPrice");
    ProductSeries.FilterCriteria = filterControl.FilterCriteria;
}

webchartcontrol-track-changes-to-the-collection-of-chart-selected-items/CS/MultiSelection/WebForm1.aspx.cs#L35

if (selectedItems == null || selectedItems.Count == 0)
    WebChartControlBars.SeriesTemplate.FilterCriteria = null;
else {

how-to-filter-a-chart-using-the-filtering-ui-context-t566197/CS/FilterCriteriaSample/Form1.cs#L29

filteringUIContext.ModelType = typeof(Product);
filteringUIContext.SetFilterCriteriaBinding(ProductSeries, s => s.FilterCriteria);
filteringUIContext.RetrieveFields();

VB.NET

how-to-filter-points-in-a-chartcontrol-series-by-using-filtercontrol-e2340/VB/FilterCriteriaSample/Form1.vb#L42

    ProductSeries.ValueDataMembers.AddRange("UnitPrice")
    ProductSeries.FilterCriteria = filterControl.FilterCriteria
End Sub

webchartcontrol-track-changes-to-the-collection-of-chart-selected-items/VB/MultiSelection/WebForm1.aspx.vb#L39

If selectedItems Is Nothing OrElse selectedItems.Count = 0 Then
    WebChartControlBars.SeriesTemplate.FilterCriteria = Nothing
Else

how-to-filter-a-chart-using-the-filtering-ui-context-t566197/VB/FilterCriteriaSample/Form1.vb#L35

filteringUIContext.ModelType = GetType(Product)
filteringUIContext.SetFilterCriteriaBinding(ProductSeries, Function(s) s.FilterCriteria)
filteringUIContext.RetrieveFields()