How to show ‘0’ in empty cells in heatmap in kibana 7.1.1?

[yuwtennis]

Link to elastic discuss
https://discuss.elastic.co/t/how-to-show-0-in-empty-cells-in-heatmap-in-kibana-7-1-1/193432

Hello .

I am using heatmap visualization and counts that are 0< are showing as expected ,
however counts that are =0 aren't showing in cells which 0 is the value that I expect to be shown. I am using terms aggregation for x and y axis. Legend displays 0 - 200 so I think 0 should be shown in the cells.

I read below post but solution was not provided so I decided to post my thread.

https://discuss.elastic.co/t/heatmap-visualisation-does-not-show-zero-for-empty-aggregation/177443

Is there anyway to show 0 using terms aggregation ?

Thanks,
Yu Watanabe

[elasticmachine]

Pinging @elastic/kibana-app (Team:KibanaApp)

[ghudgins]

for this heatmap of two terms this would have to be a heatmap fix at the chart level similar to missing value support in XY. updating this issue to reflect this.

there are other related issues about handling of null and 0 on other types #119478

as well as other related issues for handling null and 0 on color #96404

[mbondyra]

+1 from Discuss.

[stratoula]

Lens already supports it, be aware that the Hide zero values switch must be turned off

I am closing this as we dont plan to make any more optimizations to the legacy editors and as Lens already supports it, we suggest to use Lens instead!