# Kibana Lens Table: Filter Table Rows

**URL:** <https://discuss.elastic.co/t/kibana-lens-table-filter-table-rows/373286>\
**Category:** Kibana\
**Tags:** lens\
**Created:** [January 16, 2025, 3:14pm UTC](https://discuss.elastic.co/t/kibana-lens-table-filter-table-rows/373286 "2025-01-16T15:14:40Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![lavaplanet](https://avatars.discourse-cdn.com/v4/letter/l/eada6e/32.png) [@lavaplanet](https://discuss.elastic.co/u/lavaplanet)\
**Post date:** [January 16, 2025, 3:14pm UTC](https://discuss.elastic.co/t/kibana-lens-table-filter-table-rows/373286/1 "2025-01-16T15:14:40Z")

</div>

Hi there, I want to create a Kibana lens table where the rows are divided based on field values. However, I want to filter the individual rows by specific values.

 ![kibana_lens_table](https://us1.discourse-cdn.com/elastic/original/3X/3/a/3a8a1ac1da7e5bb092cdedb2a305da53a3eb1215.png)

I only want to see all rows starting with `Keyword_A`or `Keyword_B`. I don't want to see the entries starting with `Keyword_C`.

I can't use the _Filters_ option in the rows because my list is very long and dynamic. There are several entries starting with `Keyword_A` or `Keyword_B`.

If I filter the _Count of records_ for `target.keyword:Keyword_A\/*` and set the number of top values too a very high number I still can see entries starting with `Keyword_C`.

I'm using Kibana 7.16.1.

I hope that someone can help me.  
Thank you very much!

---

<div class="post-metadata">

**Author:** ![ghudgins](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/ghudgins/32/138532_2.png) [@ghudgins](https://discuss.elastic.co/u/ghudgins)\
**Post date:** [January 16, 2025, 4:05pm UTC](https://discuss.elastic.co/t/kibana-lens-table-filter-table-rows/373286/2 "2025-01-16T16:05:25Z")

</div>

can you use NOT KQL syntax `-target.keyword:Keyword_C`

---

<div class="post-metadata">

**Author:** ![lavaplanet](https://avatars.discourse-cdn.com/v4/letter/l/eada6e/32.png) [@lavaplanet](https://discuss.elastic.co/u/lavaplanet)\
**Post date:** [January 17, 2025, 7:02am UTC](https://discuss.elastic.co/t/kibana-lens-table-filter-table-rows/373286/3 "2025-01-17T07:02:11Z")

</div>

That's what I'm trying to do. But I can't find any button to add this filter.

---

<div class="post-metadata">

**Author:** ![lavaplanet](https://avatars.discourse-cdn.com/v4/letter/l/eada6e/32.png) [@lavaplanet](https://discuss.elastic.co/u/lavaplanet)\
**Post date:** [January 17, 2025, 8:44am UTC](https://discuss.elastic.co/t/kibana-lens-table-filter-table-rows/373286/4 "2025-01-17T08:44:02Z")

</div>

Aah I can just add a filter to the whole lens. Thank you very much!