Filtering data

A filter is a restriction imposed on a dataset to limit the values displayed. You create filters by choosing values or ranges of values from a dimension to include or exclude.

You can filter data in an entire dataset or in a single visualization. Filters applied to a dataset affect any chart that uses the data. However, filters applied to a visualization affect only the current chart (not the entire dataset).

In the Prepare room, you can add or edit dataset filters. All of the filters that are defined on the dataset appear in the filter bar at the top of the Data pane.

In the Visualize room, you can work with filters applied to the dataset as well as filters on the current visualization.

Example

If a dataset includes data on revenue for products sold over years between 1995 and 2012 and you only want to analyze revenue data for the years 2010 to 2012, you can create a dataset filter on the dimension Year to limit the values shown to this period.