Open options for that filter and select 'Apply to all using this data source'
Assuming you have single data source for all the sheets
Thank you for your response.Filters are working.I have 2 filters.I Want to select a value from one filter,It should show relevant values of other filter.I was applying all values in database for filter 1,only relevant values for filter 2. But In dashboard sheet selector window,when I select a value from first filter,second filter hides.
(eg. If state filter=xxx, then location filter=relevant location values only).Even when I applying "all using data source", second filter hides.
Do you have a sample workbook we can test? I have a few ideas (mainly in the dashboard action area, you can apply filters to other datasets provided they have a commonality they share), but as tech support, I need something to experiment with.