Filtering data in charts
If you use a data model as a data source for a chart, some data bindings are not persisted at runtime for performance reasons. Only data bindings used in the chart, for example for categories and values, and custom data bindings are persisted at runtime. If you want to filter on a column that is not used in the chart, you must create a data binding for the column. You can create a data binding for a chart in either of two ways:
*In the chart builder, choose the Select Data tab. Then choose Data Bindings.
*In the chart's property editor, choose the Bindings tab.
For example, you create a binding for a column of data type string called MyColumnBinding. You set the expression to data["MyString"]. Both MyColumnBinding and MyString can be used in chart filters because the column binding is persisted at runtime.