I have 2 sheets in a dashboard, each pointing to two different data sources. Couple of fields are common in both the data sources.
The first sheet is pointing to a mapping table that has static data in it. This sheet has 2 filters
Second sheet is pointing to a data table. this sheet has 4 filters and chart.
By changing the filter value in the first sheet, filters of second sheet need to be changed.
Is there any way to do it without merging these 2 datasources?
You could use parameters and calculated fields in both as the filter. The parameter crosses the sources.