Create Cascading Dropdown in Dashboard

[_its_akshaye]

I am creating a dashboard, and I am looking to implement the scenario below.

• How do I create a cascading dropdown where selecting one field filters the available values in another dropdown?
• In a dropdown, how do I show a description for each option for user selection but pass its associated ID/key as the parameter value?

Let me know if you have any ideas on how to implement it.

[pradeep_singh · Accepted solution]

Create a dataset that returns the “parent” values . Add filter A and connect it to that dataset field. Create a dataset for “child” values whose query is parameterized by the parent selection, or simply filters on the parent field:

Configure the filter widget’s Fields to use description from the choices dataset, and its Parameters to set :product_desc_param. Your query looks up the associated ID after selection. This gives users friendly labels while your query operates on IDs 

https://docs.databricks.com/aws/en/dashboards/parameters