Control do not filter cross datasets

Question & Answer
,
1

I want to filter on multiple datasets.

I have some controls on my dashboar, from 1 I can select ‘team’, this only filters on 1 dataset.
In config for the Control I’ve ticked ‘Link to a dataset field’, so maybe it’s only possible to filter one 1 dataset?

If I create a filter and apply to All visuals it filters on visuals on whole sheet even on different datasets.

Is it possible to make my dropdown Control filter on multiple datasets?

2

There is an implicit field mapping that happens when there are multiple datasets. So, if the col you are filtering on is named “team” in one dataset, and its present with same name in dataset 2, it should filter when the scope of filter is selected to “All Applicable visuals”.

1 Like