Filtering

The Dashboard Designer allows you to apply filtering to data of the Excel Data Source.

Apply Filtering

To apply filtering to a data source, click the Filter button in the Data Source Ribbon tab.

DataSourceFiltering_FilterButton_Ribbon

This will invoke the Filter Editor dialog, which allows you to build filter criteria.

DataSourceFiltering_FilterEditor

To learn how to work with the Filter Editor, see Filter Data via the Filter Editor.

To clear the data source filter, use the Clear Filter button in the Data Source Ribbon tab.

To specify the filter criteria in code, use the DashboardExcelDataSource.Filter property. To learn how to build filter criteria, see the Expression Constants, Operators, and Functions topic.

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.

How to: Pass a Dashboard Parameter to a Filter String in Code