How the Number of Datasets Affects Filters

Filters can interact differently with visualizations depending on the number of datasets, whether the datasets are joined, and what the filters are applied to.

You can filter all visualizations in a canvas or individual visualizations. Use the Limit Values options to remove or limit how the filters in the filter bar restrict each other.
Description of filter-limit-values.png follows
Description of the illustration filter-limit-values.png

If there's a single dataset in a workbook

Single Dataset Filter Interaction
Add a filter to the filter bar It applies to all visualizations in the workbook.
Add a filter to a visualization It is applied after filters on the filter bar are applied.
Add multiple filters By default filters restrict each other based on the values that you select.

If there're multiple datasets in a workbook

Multiple Datasets Filter Interaction
If you add filters to the filter bar.
  • The filters apply to all the visualizations using the joined datasets. For visualizations using the not-joined datasets, you must add a separate filter to each dataset.

  • You can't specify data elements of a dataset as a filter of other datasets, if the two datasets aren't joined.

  • If a data element of a dataset is specified as a filter, but doesn’t match the joined datasets, then the filter applies only to the visualization of that particular dataset, and does not apply to other visualizations of joined or not-joined datasets.

  • You can select Pin to All Canvases of a filter, to apply a filter to all canvases in the workbook.

If you hover over a filter name to see the visualization to which the filter is applied. Any visualizations that don't use the data element of the filter are grayed out.
If you add filters to visualizations
  • If you specify a filter on an individual visualization, that filter applies to that visualization after the filters on the filter bar are applied.

  • If you select the Use as Filter option and select the data points that are used as a filter in the visualization, then filters are generated in the other visualizations of joined datasets and matched data elements.