# Split chart hide duplicate columns with no data

**URL:** https://discuss.elastic.co/t/split-chart-hide-duplicate-columns-with-no-data/229895
**Category:** Kibana
**Created:** [April 27, 2020, 4:27am UTC](https://discuss.elastic.co/t/split-chart-hide-duplicate-columns-with-no-data/229895 "2020-04-27T04:27:34Z")
**Posts on this page:** 4
**Page:** 1

<div class="post-metadata">

### Author: ![Greg1](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/greg1/32/67160_2.png) [@Greg1](https://discuss.elastic.co/u/Greg1)
#### Post date: [April 27, 2020, 4:27am UTC](https://discuss.elastic.co/t/split-chart-hide-duplicate-columns-with-no-data/229895/1 "2020-04-27T04:27:34Z")

</div>

Hello, I would like to hide those columns with no data from the plot below. Often a split chart will be on a filtered set of the same data, and the buckets will be exclusive between the split charts (as you can see in the image).

 ![image](https://us1.discourse-cdn.com/elastic/original/3X/5/1/5124e032aba2a77449726bd9998bda1b9666af2f.png)

I used to make these types of plots with Excel Pivot tables all the time. The workaround in Excel is to "hide values with no data". Is there a way to make the plot something like this instead?

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

---

<div class="post-metadata">

### Author: ![thomasneirynck](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/thomasneirynck/32/23313_2.png) [@thomasneirynck](https://discuss.elastic.co/u/thomasneirynck)
#### Post date: [April 27, 2020, 7:33pm UTC](https://discuss.elastic.co/t/split-chart-hide-duplicate-columns-with-no-data/229895/2 "2020-04-27T19:33:05Z")

</div>

hi @Greg1,

I don't believe this exists in Kibana, but I would create an enhancement here: [https://github.com/elastic/kibana/issues/new](https://github.com/elastic/kibana/issues/new)

---

<div class="post-metadata">

### Author: ![Greg1](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/greg1/32/67160_2.png) [@Greg1](https://discuss.elastic.co/u/Greg1)
#### Post date: [April 28, 2020, 4:03am UTC](https://discuss.elastic.co/t/split-chart-hide-duplicate-columns-with-no-data/229895/3 "2020-04-28T04:03:55Z")

</div>

Thanks I raised the [feature request here](https://github.com/elastic/kibana/issues/64618).

---

<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: [May 26, 2020, 4:03am UTC](https://discuss.elastic.co/t/split-chart-hide-duplicate-columns-with-no-data/229895/4 "2020-05-26T04:03:57Z")

</div>

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