i using v0.55.12 and i want make dropdown with model like
id => value
name => label
how i can do it ? i dont see featured to make like this and always show just the id, its because my version ?
Use table metadata to tell Metabase about entity key/name relationships.
Using the Table Metadata panel in Admin, set a column as an Entity Key and another as Entity Name. Create a dashboard filter of type ID using the Entity Key column. In the filter’s dropdown, the Entity Name will appear in the filter.
i already setting entity key and entitiy name in metadata, in question i using field filter using id but in dashboard why not select ?
I was able to get this to work. Here is the setup for the SQL variable:
And here is the setup for the dashboard filter:
Make sure the dashboard filter is attached to the ID column on the dashboard card.
Thanks for showing this.
I struggled to get the desired rendered results until I found that you also need to set Filtering to “A list of all values” (instead of “Plain Input box”) on the id field. Then the dropdown will show both id and key as in your screenshot.
Just for future world wide web users out there 
