Test ID Missing from Filter Dropdown but Visible in Data Table

Q&A
,
1

Hello Community,

I’m experiencing an issue with a filter dropdown not displaying all available values from my dataset.

Setup:

  • Dataset with daily incremental refresh

  • Filter control named “Test ID” linked to field test_id

  • New test IDs are added regularly through the incremental refresh

The Problem:

  • A specific test ID value appears in my table/visual data

  • The same test ID value does NOT appear in the filter dropdown list

  • When I manually enter this test ID in a custom filter (typed filter), it works correctly and filters the data as expected

  • There are no other filters applied that would exclude this value

What I’ve Checked:

  • No filters are applied to the filter control itself

  • The test ID clearly exists in the underlying data (visible in tables)

  • Other test IDs appear normally in the dropdown

  • This only affects one specific test ID value

Question: Has anyone encountered a similar issue where a value is present in the data but missing from the filter dropdown? Is this a known issue with incremental refresh, or could there be a cache/refresh issue with the filter control?

Any suggestions on how to troubleshoot or resolve this would be greatly appreciated.

Thanks!

2

Hi @Shahar_Sasson and welcome to the Quick Community!
There was a similar post to this as another user was encountering the same issue; take a look at the attached post and let me know if the solution provided at the bottom could be a viable work around for your case:

3

Thank you so much for the help, but unfortunately, it’s quite different.

I use SPICE, not Direct Query as in that post, and it’s not a parameter, it’s the actual data from the query, not being shown in the filter.

4

Hi @Shahar_Sasson,
Thank you for clarifying. I would suggest creating a support ticket to get more direct assistance from the AWS team as this may be a bug: