I have a table (Postgres DB) with just 5 rows, and I'm using a dashboard filter (field filter on category). When I insert a new category value into the database, it:
- Appears in the table or chart data
- Does not show up in the filter dropdown
Even after running "Re-scan field values" from Admin → Databases, the filter dropdown still doesn't update.
Manually going to:
Admin → Data Model → [My Table] → [category field] → Discard saved field values
…was the only action that forced Metabase to refresh the dropdown list correctly.
Whats the solution here?