We have a dashboard we want to apply a filter for. The filter should work across the entire sheet not just for an individual visual object. There are about 2500 distinct values in the filter and here I believe QuickSight is encountering some limit issues. I am only able to apply the filter for an individual visual object. When I attempt to make the filter work for the entire sheet its value is set to “include – no one” instead of “include – everyone”. I have another filter with 600 distinct values and for this the QuickSight filter is working fine when it is applied to the entire sheet.
Hi @Mrtee and welcome to the Quick Suite Community!
When it comes to applying a filter with a large number of values, the only thing that gets limited is the list of values in the filter setup (replaced by the blue box that says there are too many distinct values). You can still change the filter to include or exclude under the ‘filter condition’.
Either way though, this filter setup (or the number of values) would not play a part in filtering one visual but not multiple/all.
When you change the ‘apply to’ option to ‘single sheet’, it will only apply the filter to visuals that are built on the same dataset as the visual where the filter originated. Are you using more than one dataset on the visuals within this sheet? If so, you may need to utilize that ‘apply cross-datasets’ option below the ‘applied to’ section:
