# Dropdown select filter not working

**URL:** <https://discuss.elastic.co/t/dropdown-select-filter-not-working/288518>\
**Category:** Kibana\
**Tags:** canvas\
**Created:** [November 5, 2021, 6:49pm UTC](https://discuss.elastic.co/t/dropdown-select-filter-not-working/288518 "2021-11-05T18:49:20Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![karwei](https://avatars.discourse-cdn.com/v4/letter/k/7bcc69/32.png) [@karwei](https://discuss.elastic.co/u/karwei)\
**Post date:** [November 5, 2021, 6:49pm UTC](https://discuss.elastic.co/t/dropdown-select-filter-not-working/288518/1 "2021-11-05T18:49:21Z")

</div>

Working with v7.14.1.

I'm trying to add a dropdown select filter to my workpad in Canvas, but it is not giving me the list of items in the dropdown. The preview data shows the list.

```auto
essql query="SELECT appId FROM \"oe.clickstream\"
group by appId"
| dropdownControl valueColumn="appId" filterColumn="appId" filterGroup="group1"
| render

```

I also tried below, but that doesn't work and the preview data does not show a unique list of appIds.

```auto
esdocs index="oe.clickstream" fields="appId"
| dropdownControl valueColumn="appId" filterColumn="appId" filterGroup="group1"
| render

```

---

<div class="post-metadata">

**Author:** ![jsanz](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/jsanz/32/53734_2.png) [@jsanz](https://discuss.elastic.co/u/jsanz)\
**Post date:** [November 15, 2021, 3:31pm UTC](https://discuss.elastic.co/t/dropdown-select-filter-not-working/288518/2 "2021-11-15T15:31:25Z")

</div>

Hi, checked on 7.14, I don't see any `filterGroup` parameter in the expression editor. Here's a example using the `kibana_sample_data_flights` and a similar SQL statement. Can you try it and see if it renders?

 ![2021-11-15_16:28:50](https://us1.discourse-cdn.com/elastic/original/3X/2/d/2d7f7f869c97567ba955348e2f60fceca11446de.png)

---

<div class="post-metadata">

**Author:** ![karwei](https://avatars.discourse-cdn.com/v4/letter/k/7bcc69/32.png) [@karwei](https://discuss.elastic.co/u/karwei)\
**Post date:** [November 16, 2021, 3:59pm UTC](https://discuss.elastic.co/t/dropdown-select-filter-not-working/288518/3 "2021-11-16T15:59:47Z")

</div>

@jsanz I removed the filterGroup and it's working now. Thanks!

---

<div class="post-metadata">

**Author:** ![karwei](https://avatars.discourse-cdn.com/v4/letter/k/7bcc69/32.png) [@karwei](https://discuss.elastic.co/u/karwei)\
**Post date:** [November 16, 2021, 4:10pm UTC](https://discuss.elastic.co/t/dropdown-select-filter-not-working/288518/4 "2021-11-16T16:10:54Z")

</div>

@jsanz I noticed I had to remove a table element that was on the page before the Dropdown select would work. Is that expected?

---

<div class="post-metadata">

**Author:** ![jsanz](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/jsanz/32/53734_2.png) [@jsanz](https://discuss.elastic.co/u/jsanz)\
**Post date:** [November 16, 2021, 4:41pm UTC](https://discuss.elastic.co/t/dropdown-select-filter-not-working/288518/5 "2021-11-16T16:41:21Z")

</div>

Not sure, but if you could open a new discussion, elaborating the steps you followed, ideally with one of the sample datasets, we can try to reproduce and eventually create an issue in our Github. Feel free to directly open the issue yourself if you can:

> **[Build software better, together](https://github.com/elastic/kibana/issues/new?assignees=&labels=bug&template=Bug_report.md)**
>
> GitHub is where people build software. More than 73 million people use GitHub to discover, fork, and contribute to over 200 million projects.

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [December 14, 2021, 4:41pm UTC](https://discuss.elastic.co/t/dropdown-select-filter-not-working/288518/6 "2021-12-14T16:41:35Z")

</div>

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.