How can I duplicate a sheet that contains a filter and adjust the filter selections in the duplicated sheet without affecting the original one? When I duplicate the sheet, the filter changes from ‘Single Sheet’ to ‘Cross Sheets.’ If I revert it to ‘Single Sheet,’ the filter is removed from the 1st sheet.
How can I maintain separate filter selections between the two sheets?
Hi Claudiu!
Would you be able to share a snippet of what you press to duplicate the sheet? I tried duplicating a sheet on a dashboard of my own, and from what I can gather my duplicate sheet doesn’t seem to be tethered to the original one at all (the filters on each tab remain to be ‘this sheet’, unlike you’ve found in your experience).
Additionally, when you try to revert it to ‘single sheet’, on which tab do you perform this operation? Have you tried doing this on both the original tab and the duplicate tab to the same effect?
I have tried changing the filter to ‘Single Sheet’ on both the original and the duplicated sheet.
I get the same message and result => the filter is removed from the other sheet.
Hi @Claudiu,
You will have to go back to the original sheet and change the filter from ‘cross-sheet’ back to ‘single sheet’.
Then you’ll have to create a new filter for the duplicated sheet.
Let us know if you have any additional questions. If we do not hear back within the next 3 business days, I’ll go ahead and close out this topic.
Thank you!
1 Like
Hi @Brett
This is the solution that I ended up with, but it’s time consuming when dealing with multiple sheets and multiple filters.
1 Like
Yes I agree and I am in the same situation. I feel this behavior was not there before!
This is a super frustrating design and is very time consuming when you don’t want cross-sheet filters. I don’t know about the rest of the community, but I never choose to use cross-sheet filters. The end users get very confused. Can the Quicksight product team please consider changing this to either allow for the option of choosing what type of filters will be on the duplicated sheet (single sheet or cross-sheet) or default to SINGLE sheet filters? Actually, what I would vote for is how it worked prior to the addition of cross-sheet filters, which is the duplicated sheet inherits the exact filters, whether they were for a visual(s) or the entire sheet.
1 Like
Can a Quicksight product manager chime in, please? Automatically creating cross-sheet filters when duplicating sheets is one of the most frustrating user experiences in Quicksight. Has it been considered by the PM team to change this functionality? I have a hard time believing that the majority of Admins and end users expect cross-sheet filters. I, for one, NEVER use them. My end users find them very confusing.