# Dropdown filter kibana canvas

**URL:** <https://discuss.elastic.co/t/dropdown-filter-kibana-canvas/187082>\
**Category:** Kibana\
**Tags:** canvas\
**Created:** [June 24, 2019, 8:39am UTC](https://discuss.elastic.co/t/dropdown-filter-kibana-canvas/187082 "2019-06-24T08:39:50Z")\
**Posts on this page:** 1\
**Showing post:** 9

<div class="post-metadata">

**Author:** ![wadhah](https://avatars.discourse-cdn.com/v4/letter/w/bc8723/32.png) [@wadhah](https://discuss.elastic.co/u/wadhah)\
**Post date:** [July 3, 2019, 4:03pm UTC](https://discuss.elastic.co/t/dropdown-filter-kibana-canvas/187082/9 "2019-07-03T16:03:10Z")

</div>

Thank you again @clintandrewhall for your help.

As I told you before : I have multiple charts in my dashboard and I am querying data from different indexes. Let's say I have two pie charts : the 1st is displaying SUM(costs) and different resources (for this I am relying on "index1"). And the 2nd chart is displaying COUNT(status) and different status (for this I am depending on "index2").  
For the filter I am using these SQL commands :  
SELECT category  
FROM index1  
WHERE category!='null'  
GROUP BY category  
-\>I've chosen "category" for "values column" also for "filter column"  
For the record, "category" is shared by both indexes by that I mean that "category" is a common field for both indexes.

So basically the filter will be applied only on the 1st pie chart however I need it to be applied on both charts. I found a solution which is to use two filters and assign each one for each chart based on "filter group name". However, I want to use just one dropdown column.  
I hope that my situation is clear now

---

_[View the full topic](https://discuss.elastic.co/t/dropdown-filter-kibana-canvas/187082)._