How Datasets Interact with Filters

There are several ways that datasets can interact with filters in a workbook.

Various factors affect the interaction of datasets and filters in workbooks:

  • The number of datasets within a workbook. See How the Number of Datasets Affects Filters.

  • The datasets that are blended or not blended (for a workbook with multiple datasets).

  • The data elements (columns) that are matched between blended datasets.

You can use the Data Diagram in the Data page of a workbook to:

  • See blended and not-blended datasets.

  • Blend or connect multiple datasets by matching the data elements in the datasets.

  • Disconnect the datasets by removing matched data elements.