I would like to find out how to do cross data source filter.
Sheet 1, Data Source A:
Sheet 2, Data Source B:
So, what I would like to do is when I add both of these sheets into a dashboard, I want to filter the fruits so that both sheets will show only the fruit that I choose from the filter.
I tried using action filter but it still fail.
The process of action filter should work. If it's not working then have a try by the process of the custom parameter, and if it fails too then, can you please share your worksheet. So that i can have a look on it.