# Heatmap hide specific column

**URL:** <https://discuss.elastic.co/t/heatmap-hide-specific-column/278170>\
**Category:** Kibana\
**Created:** [July 8, 2021, 10:07am UTC](https://discuss.elastic.co/t/heatmap-hide-specific-column/278170 "2021-07-08T10:07:27Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Celiken](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/celiken/32/72745_2.png) [@Celiken](https://discuss.elastic.co/u/Celiken)\
**Post date:** [July 8, 2021, 10:07am UTC](https://discuss.elastic.co/t/heatmap-hide-specific-column/278170/1 "2021-07-08T10:07:28Z")

</div>

Hi,

I'm trying to create a heatmap but I encounter some issues.

This is how it looked at first:

 ![withoutmindoc](https://us1.discourse-cdn.com/elastic/original/3X/f/8/f897b10c6c2a3079871a46af8a19128433f7954b.png)  
Here, the X axis is not sorted and miss values (going from 1 to 15).

I found I can fix it by adding {"min\_doc\_count":0} on the advanced tab, so now I get this:

 ![withmindoc](https://us1.discourse-cdn.com/elastic/original/3X/9/9/99056adbfddef9e93ae5dd62ec120bb890dc9e3d.png)  
Now I get the full range for the X axis, but I also get a column "0", which is a value that can never happen in our case.

Is there a way to hide this specific column without losing the 1-15 range?  
I tried adding 0 in the "exclude value" in advanced tab and excluding the value in filters, but didn't worked.

Thank you

---

<div class="post-metadata">

**Author:** ![wylie](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/wylie/32/81794_2.png) [@wylie](https://discuss.elastic.co/u/wylie)\
**Post date:** [July 8, 2021, 8:13pm UTC](https://discuss.elastic.co/t/heatmap-hide-specific-column/278170/2 "2021-07-08T20:13:20Z")

</div>

The heatmap visualization does not have the kind of customization options you're asking for. If these are required, then I would suggest that you learn how to use Vega. Vega is capable of fully custom heatmaps.

---

<div class="post-metadata">

**Author:** ![Celiken](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/celiken/32/72745_2.png) [@Celiken](https://discuss.elastic.co/u/Celiken)\
**Post date:** [July 9, 2021, 7:50am UTC](https://discuss.elastic.co/t/heatmap-hide-specific-column/278170/3 "2021-07-09T07:50:45Z")

</div>

Hello,

Thanks for your answer. I'll start looking into Vega for the next time I need it.

As a workaround, I used an "ugly-but-working" way by using a filters sub-aggregation on the X-axis, with a filter for each battery (having only 15 possible values)

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

---

<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:** [August 6, 2021, 7:50am UTC](https://discuss.elastic.co/t/heatmap-hide-specific-column/278170/4 "2021-08-06T07:50:53Z")

</div>

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