You’ve tried to add a filter widget to your dashboard, but:
If you’ve created a linked filter, please see this troubleshooting guide instead.
If you’re using a SQL variable with the variable type “field filter”, go to Troubleshooting SQL variables.
Root cause: The filter isn’t connected to any cards on the dashboard, or connected to the wrong field.
Steps to take:
Root cause: If your SQL question doesn’t contain a variable, the filter can’t insert the value into the query to filter the results.
If you built your question in the Query Builder, Metabase knows which columns you’re using, and which columns you can connect to different types of filters. So you can add a dashboard filter and refer to columns in the question’s results without creating variables explicitly.
For example, you want a dropdown but you’re seeing a search box or a text input box.
Root cause: Metabase only displays a dropdown list of possible values for a variable if it knows that the field in question is a category rather than (for example) an arbitrary number or arbitrary text. However, if the number of unique categories exceeds 100 values, Metabase will display a search box with autocomplete instead of a dropdown.
If you created the question in SQL, then you only get a dropdown if the filter is a Field Filter and the Filtering on this field option is set to your preferred input type: A list of all values (dropdown list) and the number of unique values is less than 100.
Root cause: Someone has changed the database schema, e.g., renamed or deleted a column in a table.
If a filter that used to work no longer seems to, or seems to eliminate all of the rows:
Did this article help you?
Thanks for your feedback!