# Kibana drill down on bar charts

**URL:** https://discuss.elastic.co/t/kibana-drill-down-on-bar-charts/334208
**Category:** Kibana
**Tags:** dashboard
**Created:** [May 24, 2023, 11:18am UTC](https://discuss.elastic.co/t/kibana-drill-down-on-bar-charts/334208 "2023-05-24T11:18:43Z")
**Posts on this page:** 3
**Page:** 1

<div class="post-metadata">

### Author: ![subash](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/subash/32/59912_2.png) [@subash](https://discuss.elastic.co/u/subash)
#### Post date: [May 24, 2023, 11:18am UTC](https://discuss.elastic.co/t/kibana-drill-down-on-bar-charts/334208/1 "2023-05-24T11:18:43Z")

</div>

Hi,

We are using kibana 7.17.  
In one of the use cases, it is required to drill down to a dashboard based on the clicked value in a bar chart. Attached the screenshot below.

In this case, when the user clicks on a bar (for example: TAMS-41) he should be redirected to a dashboard with filter TAMS-41. But the {{event.value}} is picking up the value in x-axis which is a date.

How do I create a drill down to filter by TAMS instead of date (x-axis)

**My drill down URL:** {{kibanaUrl}}/app/dashboards#/view/dashboard-id?\_a=(filters:!((query:(match\_phrase:('alias.TAMS ID':{{event.value}})))))

 ![image](https://us1.discourse-cdn.com/elastic/original/3X/2/6/269ed4e614aff75f886c77bba98e3973acfb1eb0.png)

---

<div class="post-metadata">

### Author: ![Marco\_Liberati](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/marco_liberati/32/82953_2.png) [@Marco\_Liberati](https://discuss.elastic.co/u/Marco_Liberati)
#### Post date: [May 25, 2023, 10:35am UTC](https://discuss.elastic.co/t/kibana-drill-down-on-bar-charts/334208/2 "2023-05-25T10:35:36Z")

</div>

Hi @subash

How did you define the drilldown? Is it a `Go to URL` or `Go to Dashboard` one?  
I've just checked with the latter and the filter is correctly applied before navigating to the new dashboard.

If you want to use the `Go to URL` one, the trick I think is to understand that `event.value` (and `event.key`) are just a shorthand for `event.points.[0].value` (and its `key` equivalent).  
So clicking on a breakdown chart like the one shown, the chart will return two data points `[x, y]`: as you note the `x` one (`timestamp`) is at index 0, while the one you are interested is at index 1.  
Use `{{event.points.[1].value}}` to retrieve the clicked category value.

---

<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: [June 22, 2023, 10:36am UTC](https://discuss.elastic.co/t/kibana-drill-down-on-bar-charts/334208/3 "2023-06-22T10:36:31Z")

</div>

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