Apply filter and then select all using related datasource option.
Please attach workbook for further.
Did you try creating a cross data source filter? Once you create Year filter, right click Apply to Worksheet --> All using related data source.
You also might need to create relationship between two data sources from Data --> Edit relationship.
Data --> Edit Relationships --> Provided the columns which you want to join or blend
Go to secondary datasourc --> click on the chain symbol
Apply the year filter (Taken from primary data source)--> Click on the filter --> Apply to relative data source
it will do the work.
Hope this helps
Plz mark this answer as correct and helpful to close the thread