# Canvas dropdown filter not showing all the values for the chosen column

**URL:** <https://discuss.elastic.co/t/canvas-dropdown-filter-not-showing-all-the-values-for-the-chosen-column/283464>\
**Category:** Kibana\
**Tags:** canvas\
**Created:** [September 6, 2021, 3:46pm UTC](https://discuss.elastic.co/t/canvas-dropdown-filter-not-showing-all-the-values-for-the-chosen-column/283464 "2021-09-06T15:46:26Z")\
**Posts on this page:** 1\
**Showing post:** 2

<div class="post-metadata">

**Author:** ![monfera](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/monfera/32/26467_2.png) [@monfera](https://discuss.elastic.co/u/monfera)\
**Post date:** [September 10, 2021, 8:12am UTC](https://discuss.elastic.co/t/canvas-dropdown-filter-not-showing-all-the-values-for-the-chosen-column/283464/2 "2021-09-10T08:12:53Z")

</div>

Hello Hamish, have you got a minimal query example of what you have tried? It's not clear what query language you use, and within that, what you have tried. For example, SQL has GROUP BY which allows grouping by unique values of a column (whether you filter on it or not).

There's indeed a record limit count both in Canvas (that you can specify with a [higher value](https://discuss.elastic.co/t/canvas-increase-result-count/178116)) and at the Elasticsearch level (which requires changes to the `elasticsearc.yaml` configuration)

---

_[View the full topic](https://discuss.elastic.co/t/canvas-dropdown-filter-not-showing-all-the-values-for-the-chosen-column/283464)._