Why you are using two same filter here. Better utilise one filter and set all relevant data sources.
Your sheet works correctly.
You do not need the manufacture filter from both datasources on the sheets.
1. Remove both filters from both sheets
2. Drop the Manufacture filter on sheet1 from datasource 'India'
3. Right click on filter to Apply for selected worksheets and select Sheet2
The filter will now apply for both sheets.
On sheet2 you will see the filter with an orange tick showing that the filter is from a secondary datasource.
You need to show the filter only once on the dashboard
Attached workbook in 10.5
Book2.twbx 162.2 KB
Thank you for the suggestion,
The solution you have provided is working perfectly.