Dashboard filters not showing all values

Hey there,

On filters in dashboards, earlier we used to see all the filters values while selecting, now it only shoes default values.
image

Hi @ankitsugandhi

Post “Diagnostic Info” from Admin > Troubleshooting.

And be “earlier we used to”, do you mean something happened after you upgraded? From which version?

The field used for the filter, what is the option set to?
Admin > Data Model > (database) > (table) > (column) :gear: > “Filtering on this field”

Hey man,

While selecting filters, I did set default values to different options(WATCH,CA,OTHERS). If I want to select only one option at a time and then change to other option I am not able to see other options. The screenshot which I have shown is when I have selected only one option, other option (i.e CA , OTHERS) I am unable to see. So how can I select multiple options for a filter?

@ankitsugandhi Please provide the information I requested above.

Hi,
Here is the screenshot.

@ankitsugandhi

  1. Post “Diagnostic Info” from Admin > Troubleshooting.
  2. And be “earlier we used to”, do you mean something happened after you upgraded? From which version?
  1. Diagnostic Info :
    {
    “browser-info”: {
    “language”: “en-GB”,
    “platform”: “Win32”,
    “userAgent”: “Mozilla/5.0 (Windows NT 6.3; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/86.0.4240.198 Safari/537.36”,
    “vendor”: “Google Inc.”
    },
    “system-info”: {
    “file.encoding”: “UTF-8”,
    “java.runtime.name”: “OpenJDK Runtime Environment”,
    “java.runtime.version”: “11.0.7+10-post-Ubuntu-2ubuntu218.04”,
    “java.vendor”: “Ubuntu”,
    “java.vendor.url”: “https://ubuntu.com/”,
    “java.version”: “11.0.7”,
    “java.vm.name”: “OpenJDK 64-Bit Server VM”,
    “java.vm.version”: “11.0.7+10-post-Ubuntu-2ubuntu218.04”,
    “os.name”: “Linux”,
    “os.version”: “5.3.0-1017-aws”,
    “user.language”: “en”,
    “user.timezone”: “Asia/Kolkata”
    },
    “metabase-info”: {
    “databases”: [
    “h2”,
    “mysql”
    ],
    “hosting-env”: “unknown”,
    “application-database”: “h2”,
    “application-database-details”: {
    “database”: {
    “name”: “H2”,
    “version”: “1.4.197 (2018-03-18)”
    },
    “jdbc-driver”: {
    “name”: “H2 JDBC Driver”,
    “version”: “1.4.197 (2018-03-18)”
    }
    },
    “run-mode”: “prod”,
    “version”: {
    “date”: “2020-10-26”,
    “tag”: “v0.37.0.2”,
    “branch”: “release-x.37.x”,
    “hash”: “ba7be09”
    },
    “settings”: {
    “report-timezone”: null
    }
    }
    }

  2. I don’t remember whether I upgraded my version or not

@ankitsugandhi

  1. Try upgrading to latest release 0.37.2
  2. And migrate away from H2 if you are using Metabase in production:
    https://www.metabase.com/docs/latest/operations-guide/migrating-from-h2.html
  3. How many distinct values does the column have?