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.