// troubleshooting guide · metabase
Metabase Filter Dropdown Not Showing Values
- Status
- Workaround available
- platforms:
- Metabase Cloud, self-hosted
- updated:
- November 16, 2026
- reports:
- 4
- Method
- how we research
RUNBOOK · metabase/filter-dropdown-empty4 FIXES
// quick answer
Dropdowns only appear for fields Metabase treats as categories with scanned values, and it samples only the first 1,000 unique values. Set the field to a dropdown in Table Metadata, then discard cached values and re-scan.
Most likely fix: Discard and re-scan field values
How to fix it
// try these in order, the most common fix is first
FIX 1Discard and re-scan field values
- 01Go to Admin > Table Metadata and pick the database and table
- 02Click the gear icon on the column
- 03Click Discard cached field values, then Re-scan this field
Did this fix it?FIX 2Set the filter type
- 01In Admin > Table Metadata, open the column
- 02Set Filtering on this field to A list of all values
- 03For very high-cardinality columns use Search box instead
Did this fix it?FIX 3Check the scan logs
- 01Go to Admin > Tools > Logs
- 02Look for scan errors on that field
Did this fix it?FIX 4Check the dashboard wiring
- 01Edit the dashboard and click the filter
- 02Make sure every card maps to the same field
- 03Remove or remap a card that uses a different table
Did this fix it?
SANDBOX · metabase RUNS IN YOUR BROWSER
Try it: browse a sample shop and watch visitors, funnels and live data arrive
A hands-on Metabase-style sandbox, including the spots where users get stuck. See where problems like this one start. 1-2 minutes, nothing is saved.
Symptoms
A dashboard filter shows a text box instead of a dropdown, the list is empty, or values are missing.
Why it happens
- C-01Field not set to show a dropdown list in Table Metadata
- C-02Field values never scanned or the scan failed
- C-03More than 1,000 unique values (Metabase samples only the first 1,000)
- C-04Long text values over the 100 KB storage limit
- C-05Dropdown set from a card using a different table
// this guide also covers
- metabase filter dropdown not showing values
- metabase dropdown filter empty
- metabase filter values missing
- metabase filter shows text box
Still not working?
If Metabase keeps failing, you're not alone. See every Metabase problem users report or the alternatives people switch to.
Done fighting Metabase? Our small team builds your own Metabase alternative, or any software you need: web, mobile, games, desktop. Price agreed together.
Talk to usThe same problem in other apps
All missing or lost data guides →
Superset CSRF Session Token Is Missing Error (Apache Superset)
Looker Studio Can't Save This Report Right Now (Looker Studio)
PostHog Events Not Showing Up (PostHog)
Other Metabase errors
- Metabase Dashboard Slow or Not Loading
- Metabase 'Your Question Took Too Long' Error
- Metabase Not Syncing New Tables or Columns
- Metabase Linked Filters Not Working
- Metabase Not Sending Emails or Alerts
- Metabase Can't Connect to Database
- Metabase Tables Not Showing
- Metabase Dates and Times Wrong (Timezone Off)