# Link two dropdown select visualisations Kibana Canvas
**URL:** https://discuss.elastic.co/t/link-two-dropdown-select-visualisations-kibana-canvas/253288
**Category:** Kibana
**Tags:** canvas
**Created:** [October 26, 2020, 10:38am UTC](https://discuss.elastic.co/t/link-two-dropdown-select-visualisations-kibana-canvas/253288 "2020-10-26T10:38:45Z")
**Posts on this page:** 7
**Page:** 1
### Author:  [@r97](https://discuss.elastic.co/u/r97)
#### Post date: [October 26, 2020, 10:38am UTC](https://discuss.elastic.co/t/link-two-dropdown-select-visualisations-kibana-canvas/253288/1 "2020-10-26T10:38:45Z")
Hi,
I've created a canvas with two dropdown selects (One for customer and one for projects)
Is there a way to link those, like a parent and child? If I select a customer in the first dropdown select. I want only to see the projects from that customer in the other dropdown select.
I'm on Kibana 7.9.3 and Elastic 7.9.1
---
### Author:  [@rashmi](https://discuss.elastic.co/u/rashmi)
#### Post date: [October 29, 2020, 10:13pm UTC](https://discuss.elastic.co/t/link-two-dropdown-select-visualisations-kibana-canvas/253288/2 "2020-10-29T22:13:03Z")
cc @poff@Catherine_Liu
---
### Author:  [@corey.robertson](https://discuss.elastic.co/u/corey.robertson)
#### Post date: [October 30, 2020, 3:22pm UTC](https://discuss.elastic.co/t/link-two-dropdown-select-visualisations-kibana-canvas/253288/3 "2020-10-30T15:22:45Z")
Hi @r97
Here is an example of how to accomplish this.
For the filter that you want to serve as the "Parent" filter, give it a FilterGroup value. The expression will look something like this:
```auto
essql query="SELECT user, order_id FROM "kibana_sample_data_ecommerce"
| dropdownControl valueColumn="user" filterColumn="user" filterGroup="by-user"
| render
```
Then, use the filter value from the parent to filter the options available in the child. It's expression will look something like.
```auto
filters group='by-user'
| essql query="SELECT user, order_id FROM "kibana_sample_data_ecommerce"
| dropdownControl valueColumn="order_id" filterColumn="order_id" filterGroup="by-order"
| render
```
Now, wherever you want to filter by the selected child value, just use `filters group="by-order"` or whatever name you give for that child group.
Hope that helps!
---
### Author:  [@r97](https://discuss.elastic.co/u/r97)
#### Post date: [November 2, 2020, 8:37am UTC](https://discuss.elastic.co/t/link-two-dropdown-select-visualisations-kibana-canvas/253288/4 "2020-11-02T08:37:54Z")
> [@corey.robertson](#):
>
> ```auto
> filters group='by-user'
> | essql query="SELECT user, order_id FROM "kibana_sample_data_ecommerce"
> | dropdownControl valueColumn="order_id" filterColumn="order_id" filterGroup="by-order"
> | render
>
> ```
Thank you! It works like a charm! Is there a way to do this also for the Dashboard dropdown controls without greying out the child value? So i could still select the child if the parent is not set?
---
### Author:  [@r97](https://discuss.elastic.co/u/r97)
#### Post date: [November 9, 2020, 7:37am UTC](https://discuss.elastic.co/t/link-two-dropdown-select-visualisations-kibana-canvas/253288/5 "2020-11-09T07:37:35Z")
@corey.robertson Have you seen my reply?
---
### Author:  [@corey.robertson](https://discuss.elastic.co/u/corey.robertson)
#### Post date: [November 10, 2020, 2:02pm UTC](https://discuss.elastic.co/t/link-two-dropdown-select-visualisations-kibana-canvas/253288/6 "2020-11-10T14:02:21Z")
Hi @r97
Hmm I'm not sure how to accomplish this in a Dashboard. The drop down controls in a dashboard are strictly populated based on the index pattern, so I'm not sure how to filter those options further.
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [December 8, 2020, 2:02pm UTC](https://discuss.elastic.co/t/link-two-dropdown-select-visualisations-kibana-canvas/253288/7 "2020-12-08T14:02:27Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.