# Showing values in a graphic bar

**URL:** <https://discuss.elastic.co/t/showing-values-in-a-graphic-bar/361025>\
**Category:** Kibana\
**Tags:** visualisation\
**Created:** [June 7, 2024, 10:34am UTC](https://discuss.elastic.co/t/showing-values-in-a-graphic-bar/361025 "2024-06-07T10:34:01Z")\
**Posts on this page:** 6\
**Page:** 2

<div class="post-metadata">

**Author:** ![juandres117](https://avatars.discourse-cdn.com/v4/letter/j/7ea924/32.png) [@juandres117](https://discuss.elastic.co/u/juandres117)\
**Post date:** [June 11, 2024, 9:39am UTC](https://discuss.elastic.co/t/showing-values-in-a-graphic-bar/361025/21 "2024-06-11T09:39:29Z")

</div>

Thank you a lot to both of you @dadoonet and @Marco_Liberati. Has been a pleasure! I will try this and hopes it work. I will leave the post and solved.  
Best of luck!!

---

<div class="post-metadata">

**Author:** ![juandres117](https://avatars.discourse-cdn.com/v4/letter/j/7ea924/32.png) [@juandres117](https://discuss.elastic.co/u/juandres117)\
**Post date:** [June 12, 2024, 6:23am UTC](https://discuss.elastic.co/t/showing-values-in-a-graphic-bar/361025/22 "2024-06-12T06:23:04Z")

</div>

Sorry to bother again. As I have to define 5 colours. Is it possible to use something similar to and/&& in formulas?

---

<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:** [June 12, 2024, 7:15am UTC](https://discuss.elastic.co/t/showing-values-in-a-graphic-bar/361025/23 "2024-06-12T07:15:05Z")

</div>

Not yet: [[Lens] Formula: add logical operators AND, OR · Issue #167390 · elastic/kibana · GitHub](https://github.com/elastic/kibana/issues/167390)

---

<div class="post-metadata">

**Author:** ![msavitski](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/msavitski/32/139920_2.png) [@msavitski](https://discuss.elastic.co/u/msavitski)\
**Post date:** [December 11, 2024, 11:06am UTC](https://discuss.elastic.co/t/showing-values-in-a-graphic-bar/361025/24 "2024-12-11T11:06:20Z")

</div>

I have used some math tricks to make it possible to assign 3 different colors to a range, so it looks like:

```auto
ifelse(ifelse(average(KPI) >= 0.3, 1, 0) * ifelse(average(KPI) < 0.5, 1, 0) > 0, average(KPI), 0)

```

But I am stuck with hiding non-values on chart hints. See the attached picture.

 ![image](https://us1.discourse-cdn.com/elastic/original/3X/b/5/b5c7c521de11464980c168870efda08f598a0df8.png)  
@Marco_Liberati Could you provide any suggestions?

---

<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:** [December 11, 2024, 11:33am UTC](https://discuss.elastic.co/t/showing-values-in-a-graphic-bar/361025/25 "2024-12-11T11:33:43Z")

</div>

I see. I think that's for now the only available solution with Lens formula.

---

<div class="post-metadata">

**Author:** ![juandres117](https://avatars.discourse-cdn.com/v4/letter/j/7ea924/32.png) [@juandres117](https://discuss.elastic.co/u/juandres117)\
**Post date:** [December 11, 2024, 11:46am UTC](https://discuss.elastic.co/t/showing-values-in-a-graphic-bar/361025/26 "2024-12-11T11:46:04Z")

</div>

Thanks @Marco_Liberati and @msavitski for your answers. Should be enough for now  
Nice to have such a good community

[Previous page](https://discuss.elastic.co/t/showing-values-in-a-graphic-bar/361025.md?page=1)