Perfect!! Very well explained. Thanks for your time
Unfortunately it didn't work for me. Let me explain my scenario,you might be able to help me with a work around!!
i have multiple reports such as bar charts, density charts, map and a table report in a dashboard.
All these reports have actions established and action on one report will filter data in others.
When dashboard loads for the first time, it will have 30,000 records.
When we apply filter on bar graph, it will filter table records.
Now when the dashboard loads for the first time, i don't want the table report to load all 30000 records. instead i want to show only 1000 random records. but if i select 3000 records on bar chart, it should show 3000 records in table report.
I cant upload the twbx file because data is confidential.
I wonder if you could make a copy of your table report sheet that would load the 1000 records, and use the "Apply to Selected Worksheets" feature of the filter Mark explained so that the filter impacts only your bar chart and the other table report. (See attached, modified from Mark's workbook).
Superstore2.twbx 339.8 KB