How the Number of Data Sets Affects Filters

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

You can add filters to the filter bar or to individual visualizations in a project.

Single Data Set Filter Interaction
Add a filter to the filter bar It applies to all visualizations in the project.
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.
Multiple Data Sets Filter Interaction
If you add filters to the filter bar.
  • The filters apply to all the visualizations using the joined data sets. For visualizations using the not-joined data sets, you must add a separate filter to each data set.

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

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

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

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 data sets and matched data elements.

You can use the Limit Values By options to remove or limit how the filters in the filter bar restrict each other.