# Can We Filter Data at the Chart-level by Column in Visual Mode?

**URL:** https://discuss.elastic.co/t/can-we-filter-data-at-the-chart-level-by-column-in-visual-mode/185606
**Category:** Kibana
**Created:** [June 13, 2019, 10:11am UTC](https://discuss.elastic.co/t/can-we-filter-data-at-the-chart-level-by-column-in-visual-mode/185606 "2019-06-13T10:11:35Z")
**Posts on this page:** 1
**Showing post:** 2

<div class="post-metadata">

### Author: ![azasypkin](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/azasypkin/32/42216_2.png) [@azasypkin](https://discuss.elastic.co/u/azasypkin)
#### Post date: [June 14, 2019, 8:47am UTC](https://discuss.elastic.co/t/can-we-filter-data-at-the-chart-level-by-column-in-visual-mode/185606/2 "2019-06-14T08:47:33Z")

</div>

Hi @Zany,

If `Total No. of Attempts` and `No. of Failed Attempts` could be rows instead of columns, you could use `Filter` aggregation to show the data you want, like demonstrated here: [Data table visualization with custom aggregation query](https://discuss.elastic.co/t/data-table-visualization-with-custom-aggregation-query/138637/2).

Best,  
Oleg

---

_[View the full topic](https://discuss.elastic.co/t/can-we-filter-data-at-the-chart-level-by-column-in-visual-mode/185606)._