Hi Dear Community,
I am currently facing an issue with the filter functionality in Metabase that used to work perfectly before. Specifically, I have a table with a field that only has three distinct values. Previously, when filtering this column, I was able to select from a dropdown list of the available values. However, after a recent update, the dropdown list no longer appears, and instead, I am only presented with options like "is," "is not," "contains," etc.
Here’s what I’ve done so far in an attempt to resolve the issue:
- Verified the field settings: I have set the field to show "A list of all values" under Admin > Data Model > Table Metadata settings, but the list still does not appear.
- Confirmed data consistency: The field contains only three distinct values, so this shouldn’t be an issue of too many values overwhelming the dropdown.
- Rescanned field values: I have rescanned the field values using the "Re-scan field values now" option under Admin > Databases, but the problem persists.
- Cleared the cache: I have cleared the cache and ensured that the schema was fully synced with the database.
- Checked data type: I have confirmed that the data type for the field is set correctly as a string/categorical type in both the database and Metabase.
- Tried different browsers and cleared browser cache: I have tried accessing Metabase from different browsers (and in incognito mode), but the issue remains.
- Reviewed permissions: I verified that there are no permission restrictions that would prevent the list from being displayed for the users.
I am currently running the latest version of Metabase, and the issue persists across multiple sessions and browsers. I would appreciate any guidance on how to resolve this issue or if this could be a bug in the current version.
Thank you in advance for your support!
Best regards,
RM
