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.