[filter]Display label(value in different column) when filtering a specific column

[duynguyenhoang]

Is your feature request related to a problem? Please describe.

Currently selection box in FilterBox only filter by value from Column configuration. It would be nice to have label and value in configuration and in FilterBox render. Let assume we have merchant_name and id_merchant, we want to show merchant_name but when filter we filter by id_merchant.

Describe the solution you'd like

• This is my suggestion for configuration

• And from new configuration, we can change data in https://github.com/apache/incubator-superset/blob/master/superset/viz.py#L2003 and https://github.com/apache/incubator-superset/blob/master/superset/viz.py#L2009.

[Papipo]

I really need this!

[junlincc]

@simcha90 @amitmiran137
I think we can add this feature to native dashboard filter config modal -> display filtered value in another column when filtering a specific column
Can we commit to this enhancement?

[suddjian]

Closing this in favor of #13398 as it has a more detailed description. This feature is in the roadmap.