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 invokes the Filter Editor dialog that allows you to build filter criteria:

DataSourceFiltering_FilterEditor

Tip

Documentation: 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.

You can use the Filter Editor to filter a data source according to the current parameter value. See the Pass Parameter Values topic for details.

Was this page helpful?

Thanks for your feedback!

How can we improve this help topic?

Add an example/code snippet.

Improve topic clarity.

Improve organization/make it easier to find.

Include additional information/content.

Additional comments/thoughts:

If you have any questions, submit a ticket to our Support Center.

Your feedback is appreciated.