# Dropdown filter kibana canvas

**URL:** <https://discuss.elastic.co/t/dropdown-filter-kibana-canvas/319315>\
**Category:** Kibana\
**Tags:** canvas\
**Created:** [November 18, 2022, 3:26pm UTC](https://discuss.elastic.co/t/dropdown-filter-kibana-canvas/319315 "2022-11-18T15:26:33Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![Gianluca\_De\_Pasquale](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/gianluca_de_pasquale/32/101527_2.png) [@Gianluca\_De\_Pasquale](https://discuss.elastic.co/u/Gianluca_De_Pasquale)\
**Post date:** [November 18, 2022, 3:26pm UTC](https://discuss.elastic.co/t/dropdown-filter-kibana-canvas/319315/1 "2022-11-18T15:26:33Z")

</div>

Hi all,

following the topic [Dropdown filter kibana canvas - Elastic Stack / Kibana - Discuss the Elastic Stack](https://discuss.elastic.co/t/dropdown-filter-kibana-canvas/187082/9) I tried to filter data on a table by using dropdown list element, but I did not succeed. I attach the code used for the sample index "kibana\_sample\_data\_ecommerce"

Dropdown:

```auto
esdocs index=kibana_sample_data_ecommerce fields=customer_gender 
| dropdownControl valueColumn=customer_gender filterColumn=customer_gender filterGroup=gender
| render

```

Table:

```auto
filters gender
| essql query="SELECT * FROM kibana_sample_data_ecommerce"
| table perPage=10 
  font={font size=14 family="'Open Sans', Helvetica, Arial, sans-serif" color="#000000" align="left"}
| render

```

Could you tell me where is the mistake? I run the last version of both Kibana and Elasticsearch.

Thanks,  
g  
@Catherine_Liu

---

<div class="post-metadata">

**Author:** ![Gianluca\_De\_Pasquale](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/gianluca_de_pasquale/32/101527_2.png) [@Gianluca\_De\_Pasquale](https://discuss.elastic.co/u/Gianluca_De_Pasquale)\
**Post date:** [November 21, 2022, 4:47pm UTC](https://discuss.elastic.co/t/dropdown-filter-kibana-canvas/319315/2 "2022-11-21T16:47:16Z")

</div>

Moreover, I would you ask whether we can filter data on a map by means of a dropdown filter, in canvas (in dashboard I tested and it is the case).  
Thanks,  
g

---

<div class="post-metadata">

**Author:** ![ppisljar](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/ppisljar/32/11588_2.png) [@ppisljar](https://discuss.elastic.co/u/ppisljar)\
**Post date:** [November 22, 2022, 10:58am UTC](https://discuss.elastic.co/t/dropdown-filter-kibana-canvas/319315/3 "2022-11-22T10:58:35Z")

</div>

`filters` function no longer exists, the new syntax to do the same is:  
`kibana | selectFilter group="gender" | ...`

---

<div class="post-metadata">

**Author:** ![Gianluca\_De\_Pasquale](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/gianluca_de_pasquale/32/101527_2.png) [@Gianluca\_De\_Pasquale](https://discuss.elastic.co/u/Gianluca_De_Pasquale)\
**Post date:** [November 22, 2022, 11:42am UTC](https://discuss.elastic.co/t/dropdown-filter-kibana-canvas/319315/4 "2022-11-22T11:42:48Z")

</div>

Hi @ppisljar ,  
many thanks. Now it works! In my opinion, the recommendation of not using `filters` function is not so clear in the documentation, is it?  
Moreover, in a canvas, is there room for filter also points in a map with the same technique or not?

Thanks,  
g.

---

<div class="post-metadata">

**Author:** ![ppisljar](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/ppisljar/32/11588_2.png) [@ppisljar](https://discuss.elastic.co/u/ppisljar)\
**Post date:** [November 22, 2022, 12:57pm UTC](https://discuss.elastic.co/t/dropdown-filter-kibana-canvas/319315/5 "2022-11-22T12:57:16Z")

</div>

I agree that docs are not clear enough.

When you talk about maps i am guessing you are using an embeddable ? embeddabe function will also accept filters but it depends on actual embeddable and filter if it can be used together. best to give it a try:

`kibana | selectFilter group="gender" | embeddable ....`

---

<div class="post-metadata">

**Author:** ![Gianluca\_De\_Pasquale](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/gianluca_de_pasquale/32/101527_2.png) [@Gianluca\_De\_Pasquale](https://discuss.elastic.co/u/Gianluca_De_Pasquale)\
**Post date:** [November 22, 2022, 2:36pm UTC](https://discuss.elastic.co/t/dropdown-filter-kibana-canvas/319315/6 "2022-11-22T14:36:08Z")

</div>

Many thanks, @ppisljar , it does work!

---

<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 20, 2022, 2:36pm UTC](https://discuss.elastic.co/t/dropdown-filter-kibana-canvas/319315/7 "2022-12-20T14:36:38Z")

</div>

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