To configure filtering in the Designer, select the target dashboard item and do one of the following.
If you are using a Ribbon menu, click the Edit Filter button in the Data tab.
Right-click a dashboard item and select Edit Filter from its context menu.
This will invoke the Filter Editor dialog. The dialog allows you to build complex filter criteria with a convenient tree-like interface. The bottom text panel can be used to enter filter expressions manually and provides syntax highlighting and autocomplete features.
Note that you can use hidden dimensions within the Filter Editor dialog, allowing you to filter data based on the values.
To clear the applied filter, select Clear from the dashboard item's context menu or click the Clear button in the Data Ribbon tab.
You can add a comment to your expression to explain it and make the expression more readable. Comments are multi-line and begin with /* and end with */.
The following code shows how to apply filtering to a dashboard item in code. Note that the DataItem.UniqueId property is specified for Dimension objects to identify these dimensions in a filter string.
ChartDashboardItem chart = new ChartDashboardItem();
Dimension issueTypeDimension = new Dimension("issueTypeID", "IssueType");
Dimension productNameDimension = new Dimension("productNameID", "ProductName");
Measure openedMeasure = new Measure("Opened", SummaryType.Count);
chart.FilterString = "issueTypeID = 'Critical' And productNameID In ('Web Forms', 'Mobile')";
Dim chart As New ChartDashboardItem()
Dim issueTypeDimension As New Dimension("issueTypeID", "IssueType")
Dim productNameDimension As New Dimension("productNameID", "ProductName")
Dim openedMeasure As New Measure("Opened", SummaryType.Count)
chart.FilterString = "issueTypeID = 'Critical' And productNameID In ('Web Forms', 'Mobile')"
Pass Parameter Values
You can use the Filter Editor to filter a data source according to the current parameter value. To learn more, see the Passing Parameter Values topic.
You cannot apply filtering by building complex filter criteria in OLAP mode. Instead, you can filter dimension attributes and hierarchies by manually selecting the values you wish (or do not wish) to include in the dashboard.
For dimension attributes, the Filter Editor contains a list of all values.
For hierarchies, a tree is displayed instead, allowing you to filter individual values at any hierarchy level.