Create a filtered dropdown filter

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 ?

Hi @ThibaudD
Dropdown values comes from the scanned field. You are likely looking for this: - upvote by clicking :+1: on the first post
You can get part of the way with Linked Filters: