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 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:
Hi @Mrtee,
Apologies for missing your last response, please make sure to tag the person you’re replying to in responses so that they get notified.
Whenever you’re using a field that has more than 1,000 unique values, you will not be able to ‘select’ the values you’d like to include; instead you receive a message in the blue box that says there are too many distinct values’ and that you need to search for them’. So because there are too many values to display in the filter panel during setup, since you have not ‘selected’ any values, once you hit apply, it recognizes that no values have been selected and therefore changes to ‘None’.
So if you switch the filter condition option to ‘Exclude’ instead of ‘Include’, all of your visuals will populate as no values will be selected to exclude.
To work around this; I would suggest setting up a parameter control for your ‘orgnr’ field. Then when creating your filter, you can set to ‘custom filter’ instead of ‘filter list’ and can link it up to the parameter.
This will avoid the issue of no data showing up.
