Currently, filter controls in QuickSight display all values from the associated dataset field, regardless of the specific data displayed in the dashboard. I would like to request a feature enhancement: the ability to dynamically limit filter control values to those relevant to the data currently visible in the dashboard (i.e., after applying other filters or based on visual contexts).
This functionality would significantly enhance user experience by providing more intuitive and context-specific filtering options, especially for complex dashboards with cascading or dependent filters.
Is this feature currently on the roadmap, or are there any potential workarounds to achieve this functionality?
When you’re editing your filter control, there’s a Show relevant values only option at the bottom. Click on it to see a list of all other controls on your sheet. You can then select any of those controls to create the dependency.
Please refer to the below documentation and video this might be helpful for you.
Hello,
I noticed that the filter dropdown currently shows values, such as team names, that may not have any issues closed. I’m looking for a way to modify this behavior so that the dropdown only displays options where there is some value (i.e., non-null values).
For example, I’m trying to create a pivot table to find the number of issues closed by team names. It would be helpful if the filter dropdown only included team names that have at least one issue closed.
I appreciate your response and guidance on whether this feature is supported or if there’s a workaround to achieve this.
But to limit the results in your parameter, you would need to setup another parameter for your ‘issue closed’ and then set the team parameter to only show relevant values based on the issue closed parameter.
I believe those would be your two best work around options for this case. Let us know if you have any additional questions!
