Copilot said: Has anyone experienced a QuickSight filter dropdown/search not showing values when certain dashboard filters are applied, even though the distinct value count is below 1,000, and can help identify the root cause

Q&A
,
1

We are using Amazon Redshift exposed views in QuickSight to create datasets (direct query with parameter controls ) and built dashboards. We are facing an issue with filter controls on the dashboard.

When the relevant values are applied in filters, the filter dropdown/search box does not display any values. However, when those relevant values to filters are removed, the dropdown populates correctly and users can search/select values. The distinct value count for the filter is well below 1,000, so it does not appear to be related to the value limit.

Has anyone experienced similar behavior in QuickSight?

Some points we are trying to understand:

Why does the filter dropdown stop showing values when relevant values are applied?
Is this expected behavior based on how QuickSight handles dependent/cascading filters?
Could this be related to the Redshift view design, Direct Query/SPICE mode, dataset joins or filter evaluation order?
Are there any known limitations or performance considerations that could cause this issue even when the distinct values are less than 1,000?

Any insights into the root cause, troubleshooting steps, or recommended best practices would be greatly appreciated

2

Hi @nnaik06,

That is definitely some interesting behavior, as I do not believe there are any limitations when it comes to relevant values (especially if your distinct values are less than 100). Just so I can understand better, could you please provide a screenshot of your filter controls not displaying any values, while also showing the relevant values toggled/untoggled?

Thank you!

3

Hi @nnaik06,

Just checking back in since this thread hasn’t received a response in a while. Was my reply helpful to you and/or were you able to find a solution yourself in the meantime? Please help the community by marking this answer as “Solution” or following up in general within the next 3 business days!

Thank you!

4

Hi @nnaik06,

Since I haven’t received any further updates from you, I’ll treat this inquiry as complete at this time. Please feel free to create a new post if you have more questions.

Thank you.