Hello. The main issue I've is that my dropdown filter does not populate the values for a string/category variable. Instead, I always get a "search box," and the dropdown does not show the distinct values of the field.
I've gone through past threads about this issue like these without being able to find a solution:
- Dropdown Filter sometimes does not populated
- Dropdown filter not populating
- Filter dropdowns do not populate in embeds
- Filter with no dropdown
In one of those solutions, it says that I get the "search box" because there are too many values. Hence, I created a new table with just one column containing two distinct values (male and female). Despite this, the search box still pops up when I open the filter, even after I have defined the field as a Category through Metabase Admin Settings.
I have already:
- Verified that the column contains consistent values and no nulls.
- Changed the Field Type in the Data Model to Category.
- Synced and re-scanned the database.
- Tried simpler SQL queries, explicitly referencing the field with
{{ gender }}orIN ({{ gender }}).
What might I be missing here? Any help would be appreciated!