# Is it possible to filter in Kibana based on fields not rendered in a visualisation? **URL:** \ **Category:** Kibana\ **Created:** [May 17, 2016, 7:39pm UTC](https://discuss.elastic.co/t/is-it-possible-to-filter-in-kibana-based-on-fields-not-rendered-in-a-visualisation/50256 "2016-05-17T19:39:24Z")\ **Posts on this page:** 10\ **Page:** 1
**Author:** ![daniel-burke](https://avatars.discourse-cdn.com/v4/letter/d/3bc359/32.png) [@daniel-burke](https://discuss.elastic.co/u/daniel-burke)\ **Post date:** [May 17, 2016, 7:39pm UTC](https://discuss.elastic.co/t/is-it-possible-to-filter-in-kibana-based-on-fields-not-rendered-in-a-visualisation/50256/1 "2016-05-17T19:39:24Z")
This is probably easier to describe using an example. If I have records like: User { "username" : "xxxxxx", "user\_id" : "12345" } When I render a visualisation based on username I can click on one of the usernames to add a filter with it. What I want to be able to do is add a filter with user\_id instead? ---
**Author:** ![fred-d](https://avatars.discourse-cdn.com/v4/letter/f/cc9497/32.png) [@fred-d](https://discuss.elastic.co/u/fred-d)\ **Post date:** [May 18, 2016, 7:14am UTC](https://discuss.elastic.co/t/is-it-possible-to-filter-in-kibana-based-on-fields-not-rendered-in-a-visualisation/50256/2 "2016-05-18T07:14:43Z")
You can edit a filter by clicking on its right icon. Then just replace "username" with "user\_id" and change the query to what you need. ---
**Author:** ![daniel-burke](https://avatars.discourse-cdn.com/v4/letter/d/3bc359/32.png) [@daniel-burke](https://discuss.elastic.co/u/daniel-burke)\ **Post date:** [May 18, 2016, 2:48pm UTC](https://discuss.elastic.co/t/is-it-possible-to-filter-in-kibana-based-on-fields-not-rendered-in-a-visualisation/50256/3 "2016-05-18T14:48:06Z")
Thanks - I'm looking for a way to make this a single click so non-kibana experts can click through the UI to drill down. I guess this isn't possible? ---
**Author:** ![fred-d](https://avatars.discourse-cdn.com/v4/letter/f/cc9497/32.png) [@fred-d](https://discuss.elastic.co/u/fred-d)\ **Post date:** [May 18, 2016, 6:26pm UTC](https://discuss.elastic.co/t/is-it-possible-to-filter-in-kibana-based-on-fields-not-rendered-in-a-visualisation/50256/4 "2016-05-18T18:26:56Z")
You can add filters to a dashboard and save it all together (including your edit and whether a filter is deactivated). ---
**Author:** ![Bargs](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/bargs/32/5429_2.png) [@Bargs](https://discuss.elastic.co/u/Bargs)\ **Post date:** [May 18, 2016, 10:12pm UTC](https://discuss.elastic.co/t/is-it-possible-to-filter-in-kibana-based-on-fields-not-rendered-in-a-visualisation/50256/5 "2016-05-18T22:12:17Z")
On a dashboard, you could also add a data table visualization with a list of users and put it next to the visualization you'd like to filter. Users could click on the entries in the data table and it would filter the entire dashboard. ---
**Author:** ![sjivan](https://avatars.discourse-cdn.com/v4/letter/s/c57346/32.png) [@sjivan](https://discuss.elastic.co/u/sjivan)\ **Post date:** [December 15, 2016, 4:59am UTC](https://discuss.elastic.co/t/is-it-possible-to-filter-in-kibana-based-on-fields-not-rendered-in-a-visualisation/50256/6 "2016-12-15T04:59:06Z")
I have a similar requirement to only display the field values as a list / table without a chart / visualization associated with it. A datatable format would be okay but datatable requires one to select a metric so the table will now have an extra count / metic column in addition to the column of the field I'd to filter on. Is there a way to have the datatable display only one column without the metric column? Thanks, Sanjiv ---
**Author:** ![sjivan](https://avatars.discourse-cdn.com/v4/letter/s/c57346/32.png) [@sjivan](https://discuss.elastic.co/u/sjivan)\ **Post date:** [December 15, 2016, 11:43am UTC](https://discuss.elastic.co/t/is-it-possible-to-filter-in-kibana-based-on-fields-not-rendered-in-a-visualisation/50256/7 "2016-12-15T11:43:06Z")
I found another thread [Data table :hide column Count](https://discuss.elastic.co/t/data-table-hide-column-count/53037) that confirms that the Metric column cannot be removed / hidden so I used a bit of a hack to get as close to the desired results as I could short of writing a plugin. I added a dummy numeric field to my document that has a null value for all records and in the data table I select the Metric as Max (or Min) of this field and use a label of \_ or . to make the column as close to invisible as I can. Sadly column label doesn't accept markup so   doesn't work but this is what I'll have to work with for now. Definitely a fundamental building block viz that is missing from Kibana. ![](https://us1.discourse-cdn.com/elastic/original/2X/3/3f319aaa678b19516f8a872ff49990167aceec32.jpg) ---
**Author:** ![Bargs](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/bargs/32/5429_2.png) [@Bargs](https://discuss.elastic.co/u/Bargs)\ **Post date:** [December 15, 2016, 3:46pm UTC](https://discuss.elastic.co/t/is-it-possible-to-filter-in-kibana-based-on-fields-not-rendered-in-a-visualisation/50256/8 "2016-12-15T15:46:26Z")
Should be a fairly easy enhancement, I'd recommend filing a request on our [Github repo](https://github.com/elastic/kibana/issues/new). ---
**Author:** ![sjivan](https://avatars.discourse-cdn.com/v4/letter/s/c57346/32.png) [@sjivan](https://discuss.elastic.co/u/sjivan)\ **Post date:** [December 15, 2016, 5:25pm UTC](https://discuss.elastic.co/t/is-it-possible-to-filter-in-kibana-based-on-fields-not-rendered-in-a-visualisation/50256/9 "2016-12-15T17:25:30Z")
Filed request : [https://github.com/elastic/kibana/issues/9507](https://github.com/elastic/kibana/issues/9507) Thanks, Sanjiv ---
**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\ **Post date:** [July 6, 2017, 1:33pm UTC](https://discuss.elastic.co/t/is-it-possible-to-filter-in-kibana-based-on-fields-not-rendered-in-a-visualisation/50256/10 "2017-07-06T13:33:41Z")