// 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
Share

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

  1. FIX 1Discard and re-scan field values

    1. 01Go to Admin > Table Metadata and pick the database and table
    2. 02Click the gear icon on the column
    3. 03Click Discard cached field values, then Re-scan this field
    Did this fix it?
  2. FIX 2Set the filter type

    1. 01In Admin > Table Metadata, open the column
    2. 02Set Filtering on this field to A list of all values
    3. 03For very high-cardinality columns use Search box instead
    Did this fix it?
  3. FIX 3Check the scan logs

    1. 01Go to Admin > Tools > Logs
    2. 02Look for scan errors on that field
    Did this fix it?
  4. FIX 4Check the dashboard wiring

    1. 01Edit the dashboard and click the filter
    2. 02Make sure every card maps to the same field
    3. 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 us

Watch Metabase Get an email when its price changes, it has an outage, or we publish a new fix. No spam.

Fixed it? Share this guide

The same problem in other apps

All missing or lost data guides →

Other Metabase errors

All 14 Metabase errors and fixes →