# Filter Data Table Column Using Dropdown Filter **URL:** \ **Category:** Kibana\ **Created:** [August 12, 2019, 11:06pm UTC](https://discuss.elastic.co/t/filter-data-table-column-using-dropdown-filter/194928 "2019-08-12T23:06:28Z")\ **Posts on this page:** 5\ **Page:** 1
**Author:** ![r\_singh10](https://avatars.discourse-cdn.com/v4/letter/r/e5b9ba/32.png) [@r\_singh10](https://discuss.elastic.co/u/r_singh10)\ **Post date:** [August 12, 2019, 11:06pm UTC](https://discuss.elastic.co/t/filter-data-table-column-using-dropdown-filter/194928/1 "2019-08-12T23:06:28Z")
Imagine a table with 4 columns. Is there a way I can use the Dropdown Filter element within Canvas to only show the selected columns within the table? For example, look at this table found on [Apple.com](http://Apple.com). ![48%20PM](https://us1.discourse-cdn.com/elastic/original/3X/d/4/d4348b87132b56b0c43da124d82b118af3620cd9.jpeg) Notice how you can select an iPhone model from the dropdown, and the column updates to show info pertaining to that iPhone model. What I am trying to do does not include images, but only text. Is there a way I can use the Dropdown Filter element to select a column's name, and it display that column in the Data Table? ---
**Author:** ![lukas](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/lukas/32/6812_2.png) [@lukas](https://discuss.elastic.co/u/lukas)\ **Post date:** [August 13, 2019, 11:01pm UTC](https://discuss.elastic.co/t/filter-data-table-column-using-dropdown-filter/194928/2 "2019-08-13T23:01:53Z")
Sure, do you mind sharing what you've got so far, including the expressions backing the elements? In general, if your expression for an element begins with `filters |` then any datasource should be filtering based on the selection in the drop down. However, you have to make sure the drop down is configured to apply to the correct field in your data. ---
**Author:** ![r\_singh10](https://avatars.discourse-cdn.com/v4/letter/r/e5b9ba/32.png) [@r\_singh10](https://discuss.elastic.co/u/r_singh10)\ **Post date:** [August 14, 2019, 10:20pm UTC](https://discuss.elastic.co/t/filter-data-table-column-using-dropdown-filter/194928/3 "2019-08-14T22:20:37Z")
Hi Lukas, I've attached a screenshot of my CSV file and the screenshot of my Canvas. As you see, I have 16 columns on the CSV file, but for my Canvas I have 5 columns. As you see in terms of design, there are 4 drop-downs on top of 4 columns. I want to be able to switch between the 16 columns in the CSV using the drop-downs in Canvas. So for example, in Canvas, the drop down should give me options of 16 different columns (maker, model, mileage, manufacture\_year, etc.), and the column underneath should change and display the data for the requested column. Is this doable? ![03%20PM](https://us1.discourse-cdn.com/elastic/original/3X/c/2/c2c26d4e4ce58bdd8b4e5b1bc97e183e050bf1ba.jpeg) ![20%20PM](https://us1.discourse-cdn.com/elastic/original/3X/e/f/efcb889ed0afa134b7735d0151412a56722e8e32.png) ---
**Author:** ![lukas](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/lukas/32/6812_2.png) [@lukas](https://discuss.elastic.co/u/lukas)\ **Post date:** [August 27, 2019, 10:54pm UTC](https://discuss.elastic.co/t/filter-data-table-column-using-dropdown-filter/194928/4 "2019-08-27T22:54:58Z")
Unfortunately this isn't currently possible. The drop down filter can only be used to filter rows from your data, not columns. ---
**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\ **Post date:** [September 24, 2019, 10:55pm UTC](https://discuss.elastic.co/t/filter-data-table-column-using-dropdown-filter/194928/5 "2019-09-24T22:55:05Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.