Create a filtered dropdown filter

Get Help
1

I got an issue about the dropdown filter option on my dashboards. I don't manage to create a filter which would propose only a pre-filtered data.

My use case is the following:

I got a supplier list and I wish that the dropdown filter only propose the suppliers which are in a "question" result or in my SQL query results.

I tried a lot of things in the attempt of pre-filtering the data (questions on filtered model, questions on a SQL request) but it seems that Metabase always propose the entire column of the correspoing database table. Is there a way around it ?

2

Hi @ThibaudD
Dropdown values comes from the scanned field. You are likely looking for this:
https://github.com/metabase/metabase/issues/5245 - upvote by clicking :+1: on the first post
You can get part of the way with Linked Filters:
https://www.metabase.com/learn/dashboards/linking-filters.html