# How to change value on pie charts using lense

**URL:** <https://discuss.elastic.co/t/how-to-change-value-on-pie-charts-using-lense/260990>\
**Category:** Kibana\
**Created:** [January 13, 2021, 11:54am UTC](https://discuss.elastic.co/t/how-to-change-value-on-pie-charts-using-lense/260990 "2021-01-13T11:54:57Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![tahseen\_fatima](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/tahseen_fatima/32/67789_2.png) [@tahseen\_fatima](https://discuss.elastic.co/u/tahseen_fatima)\
**Post date:** [January 13, 2021, 11:54am UTC](https://discuss.elastic.co/t/how-to-change-value-on-pie-charts-using-lense/260990/1 "2021-01-13T11:54:57Z")

</div>

Hi,

I have a setup of ELK 7.10.0v.  
I made pie chart using lense there I want to change the value at the end of the number in pie chart to Million and in Billions for making easy to understand.

 ![image](https://us1.discourse-cdn.com/elastic/original/3X/b/e/be7a08c1e8ace8d15b5344b88cd6a4311a80e771.png)

Please suggest me how to change this.

Regards,  
Tahseen

---

<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:** [January 13, 2021, 2:44pm UTC](https://discuss.elastic.co/t/how-to-change-value-on-pie-charts-using-lense/260990/2 "2021-01-13T14:44:57Z")

</div>

I work on Lens, and we haven't made a simple formatter for this yet. So for now you'll need to set the formatting options in a different part of Kibana. You have two options:

1. Assign a formatter to the field in your index pattern. Specifically you can use the number format pattern `0,0a` which will produce numbers like "208m" or "1b" instead of the values you're seeing. You could also do `0,0.0a` which will show `1.4b` instead of what you're seeing.

2. Use a scripted field to do simple math like `doc['field'].value / 1000000`. This is separate from the formatter, but some users find this useful.

---

<div class="post-metadata">

**Author:** ![tahseen\_fatima](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/tahseen_fatima/32/67789_2.png) [@tahseen\_fatima](https://discuss.elastic.co/u/tahseen_fatima)\
**Post date:** [January 14, 2021, 5:54am UTC](https://discuss.elastic.co/t/how-to-change-value-on-pie-charts-using-lense/260990/3 "2021-01-14T05:54:32Z")

</div>

Hi @wylie,

I followed the option 1, and it worked.  
Thank you for the solution.

Regards,  
Tahseen

---

<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:** [February 11, 2021, 5:54am UTC](https://discuss.elastic.co/t/how-to-change-value-on-pie-charts-using-lense/260990/4 "2021-02-11T05:54:39Z")

</div>

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