I think an Action Filter should work. Alternatively create a third data source with all your filter options and relate it to your data sources. You can then apply your filters across all sheets that use this filter data source.
Hope that makes sense!
What exactly would an action filter do that the quick filter wouldn't? I've never used them before and will dive into that exploration this morning.
Alright so it is looking like the point of filter actions is to just filter the data for one dashboard, but I am trying to do it across 4 different ones so I am not sure that's the right option. Am I missing something?
And I tried to create an additional data source that was just the two field that I wanted to filter on and I still didn't have the option to only display the relevant values on the second filter.
Did I misunderstand what you were recommending?
Running into the same problem and somehow can't find it any documentation. Posting just to bump the conversation up.
I am facing the same problem too but on the views where primary data source is different . Only relevant values is not available hence cascading effect is not happening. Quite sad the feature was not properly tested