# Canvas dropdown filter **URL:** \ **Category:** Kibana\ **Tags:** canvas\ **Created:** [June 10, 2019, 2:40pm UTC](https://discuss.elastic.co/t/canvas-dropdown-filter/185006 "2019-06-10T14:40:03Z")\ **Posts on this page:** 1\ **Showing post:** 4
**Author:** ![tims](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/tims/32/46750_2.png) [@tims](https://discuss.elastic.co/u/tims)\ **Post date:** [June 17, 2019, 2:37pm UTC](https://discuss.elastic.co/t/canvas-dropdown-filter/185006/4 "2019-06-17T14:37:20Z")
Ok, so I think that you need to update your Costs query to be grouped by ConsumedService so that the value that you are passing in via filterColumn will actually have a corresponding column in the Costs query. If you visualize your Costs query as a datatable you will see that right now it is only returning the total sum not broken out by ConsumedService. Here is a similar question that was posted a while back that may give you a better idea of some things to try. > [@Canvas dropdownfilter does not filter](https://discuss.elastic.co/t/canvas-dropdownfilter-does-not-filter/161950): > > I'm working on my first Canvas and want to show statistics about my payment brands in my shop, including a time filter and a payment brand filter: Everything works as I want, except for the payment brands filter. After some fiddling, I did get to populate it correctly but when I select one of the payment brands, the chart is not filtered based on that brand (which is my goal) and throws an error (that is gone very quickly, so I had to record my actions to be able to se… --- _[View the full topic](https://discuss.elastic.co/t/canvas-dropdown-filter/185006)._