# Kibana Dashboard Filter - Based on Columns

**URL:** https://discuss.elastic.co/t/kibana-dashboard-filter-based-on-columns/327695
**Category:** Kibana
**Tags:** visualisation
**Created:** [March 14, 2023, 6:29pm UTC](https://discuss.elastic.co/t/kibana-dashboard-filter-based-on-columns/327695 "2023-03-14T18:29:31Z")
**Posts on this page:** 4
**Page:** 1

<div class="post-metadata">

### Author: ![Raj4](https://avatars.discourse-cdn.com/v4/letter/r/b5a626/32.png) [@Raj4](https://discuss.elastic.co/u/Raj4)
#### Post date: [March 14, 2023, 6:29pm UTC](https://discuss.elastic.co/t/kibana-dashboard-filter-based-on-columns/327695/1 "2023-03-14T18:29:31Z")

</div>

Hi,  
Please advise to achieve the below requirement

**Data Fields and Sample Values**

![SampleData](https://us1.discourse-cdn.com/elastic/original/3X/3/e/3e407a153c67205f94467edab5a9f9fc46a2d8f6.jpeg)

I want to have only one Bar chart which should top 3 person name based upon the selected filter.

The Dashboard filter should have the column names **Sales, Commission, Salary, Bonus**

If I select **Sales** from the Option List Dashboard filter, the chart should show top 3 person name based upon the Sales.

If I select **Commission** from the Option List Dashboard filter, the chart should show top 3 person name based upon the Commission.

Note: Only one chart serve the purpose of all the different field top values.

---

<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: [April 11, 2023, 6:30pm UTC](https://discuss.elastic.co/t/kibana-dashboard-filter-based-on-columns/327695/2 "2023-04-11T18:30:04Z")

</div>

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

---

<div class="post-metadata">

### Author: ![drewdaemon](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/drewdaemon/32/97779_2.png) [@drewdaemon](https://discuss.elastic.co/u/drewdaemon)
#### Post date: [April 11, 2023, 6:52pm UTC](https://discuss.elastic.co/t/kibana-dashboard-filter-based-on-columns/327695/3 "2023-04-11T18:52:34Z")

</div>



---

<div class="post-metadata">

### Author: ![drewdaemon](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/drewdaemon/32/97779_2.png) [@drewdaemon](https://discuss.elastic.co/u/drewdaemon)
#### Post date: [April 11, 2023, 6:59pm UTC](https://discuss.elastic.co/t/kibana-dashboard-filter-based-on-columns/327695/4 "2023-04-11T18:59:35Z")

</div>

Hi @Raj4 ! Unfortunately, this is not possible with dashboard filters. They are only designed to exclude certain portions of the data. There is no way to hook them up to a visualization to dynamically change the visualization config.

If a table view would be okay, I wonder if an embedded [saved search](https://www.elastic.co/guide/en/kibana/master/save-load-delete-query.html) might work for you? That approach allows you to sort by whatever column you want, effectively giving you the top three of whichever column you selected.

 ![Screenshot 2023-04-11 at 1.55.28 PM](https://us1.discourse-cdn.com/elastic/original/3X/4/6/46dd7f94da33a4224a2930572ab4c5677e5e2297.png)
