Ultimately, your ask is essentially what happens when you're creating a new dashboard and you select some filter fields from the right side. The challenge here, however, is that you want this to be available to the user, and not simply at creation time. Long story short, I don't think you can do it using plain BI in Databricks, so here are a couple of other (more powerful and user friendly) options.
The first would be a custom Databricks App. With vibe coding being what it is today, this shouldn't be too terribly difficult to accomplish if you have access to Claude Code or Cursor (or some similar code-generation tools). With a Databricks App, you can basically do whatever you want, and even include such nice flourishes as having car company logos, or actual color swatches in the dropdown, etc etc.
The other (and in my opinion, the best) option could be to put this table in a Genie space and let people interact from there. It would allow people to have a conversation with the data itself, and would probably eliminate the need for the direct filtering. Instead of using dropdowns, then, the user would just type something like: "Show me all the unowned vehicles that are red or gray, and located within 100 miles of zip code 90210." and the system would comply.
My personal opinion on this is that a Genie Space would be the first thing I'd go for, and if that isn't enough, go for a Databricks App.
To prove out the point, I created a dataset of cars (in my situation, I used about 5 dimensions just to prove out the point), and then I tossed that one dataset into a genie space, and asked it to show me all the Gray Toyotas. The output image is attached... notice that it was smart enough to replace my ask (gray) with the closest listed color (silver), and it even explained why it searched for silver instead of gray.
After it gave me this list, I asked it to further refine it to only hybrid or electric 2025 models, and it complied without issue.
Long story short, a dashboard is probably the wrong tool for this particular job. Go for a Genie Space.
