# Canvas Filter Dropdown Not Working

**URL:** <https://discuss.elastic.co/t/canvas-filter-dropdown-not-working/248737>\
**Category:** Kibana\
**Tags:** canvas\
**Created:** [September 15, 2020, 8:37pm UTC](https://discuss.elastic.co/t/canvas-filter-dropdown-not-working/248737 "2020-09-15T20:37:57Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Brandon\_Liles](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/brandon_liles/32/71903_2.png) [@Brandon\_Liles](https://discuss.elastic.co/u/Brandon_Liles)\
**Post date:** [September 15, 2020, 8:37pm UTC](https://discuss.elastic.co/t/canvas-filter-dropdown-not-working/248737/1 "2020-09-15T20:37:57Z")

</div>

I have what I think should be a simple use case for Kibana canvas (Kibana 7.8.1), this is the query:

```auto
filters
| timelion query=".es(index=the-index*)"
| pointseries x="@timestamp" y="value"
| plot defaultStyle={seriesStyle points="0" lines="4" bars="0"}
| render

```

I've added a date filter (which works) and I'm trying to add a filter on the field in the index. I'm using Group By to get a distinct set of company names.

```auto
essql
query="SELECT CompanyName.raw FROM \"the-index*\"
WHERE CompanyName.raw IS NOT NULL
GROUP By CompanyName.raw"
| dropdownControl valueColumn="CompanyName.raw" filterColumn="CompanyName.raw"
| render

```

The CompanyName.raw field is a keyword field in the-index. Selecting options from the dropdown does not filter query at all.

Please help.

---

<div class="post-metadata">

**Author:** ![Marta\_Bondyra](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/marta_bondyra/32/102122_2.png) [@Marta\_Bondyra](https://discuss.elastic.co/u/Marta_Bondyra)\
**Post date:** [October 12, 2020, 10:34am UTC](https://discuss.elastic.co/t/canvas-filter-dropdown-not-working/248737/2 "2020-10-12T10:34:42Z")

</div>

Hi,

sorry for the late reply. Did you in the end manage to solve your issue?

---

<div class="post-metadata">

**Author:** ![Brandon\_Liles](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/brandon_liles/32/71903_2.png) [@Brandon\_Liles](https://discuss.elastic.co/u/Brandon_Liles)\
**Post date:** [October 12, 2020, 12:20pm UTC](https://discuss.elastic.co/t/canvas-filter-dropdown-not-working/248737/3 "2020-10-12T12:20:05Z")

</div>

No, I tried again last week and had the same results. Any ideas?

---

<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:** [November 9, 2020, 12:20pm UTC](https://discuss.elastic.co/t/canvas-filter-dropdown-not-working/248737/4 "2020-11-09T12:20:15Z")

</div>

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