# Displaying numbers as 1M,1B,1K in kibana **URL:** \ **Category:** Kibana\ **Created:** [December 21, 2020, 7:49am UTC](https://discuss.elastic.co/t/displaying-numbers-as-1m-1b-1k-in-kibana/259227 "2020-12-21T07:49:23Z")\ **Posts on this page:** 8\ **Page:** 1
**Author:** ![RamyaGowda](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/ramyagowda/32/27440_2.png) [@RamyaGowda](https://discuss.elastic.co/u/RamyaGowda)\ **Post date:** [December 21, 2020, 7:49am UTC](https://discuss.elastic.co/t/displaying-numbers-as-1m-1b-1k-in-kibana/259227/1 "2020-12-21T07:49:23Z")
Hi Team, I'm are using Visual builder to show some metrices over the time, as these number are very big I have customized the format as "0.0a" It shows the number in proper format ,but the issue is with the abbreviation How can this abbreviations be changed to Uppercase? Instead of "7.70b" I would like to display it as "7.70B" ![image](https://us1.discourse-cdn.com/elastic/original/3X/e/9/e96dec172e6919d42a5146aeb8b145512faea7d3.png) Seeking help! Thanks in Advance, Ramya ---
**Author:** ![ylasri](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/ylasri/32/86120_2.png) [@ylasri](https://discuss.elastic.co/u/ylasri)\ **Post date:** [December 21, 2020, 8:10am UTC](https://discuss.elastic.co/t/displaying-numbers-as-1m-1b-1k-in-kibana/259227/2 "2020-12-21T08:10:12Z")
HI @RamyaGowda In TSVB there is an option to format automtically Bytes into KB, MB, TB .... ![image](https://us1.discourse-cdn.com/elastic/original/3X/4/9/492380f4474baadc825ceed1f7ca7d521a89607b.png) ---
**Author:** ![RamyaGowda](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/ramyagowda/32/27440_2.png) [@RamyaGowda](https://discuss.elastic.co/u/RamyaGowda)\ **Post date:** [December 21, 2020, 8:36am UTC](https://discuss.elastic.co/t/displaying-numbers-as-1m-1b-1k-in-kibana/259227/3 "2020-12-21T08:36:54Z")
@ylasri, Thanks for your reply ! I'm trying to display number in form on millions, billions not Bytes. Thanks, Ramya ---
**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:** [December 21, 2020, 4:11pm UTC](https://discuss.elastic.co/t/displaying-numbers-as-1m-1b-1k-in-kibana/259227/4 "2020-12-21T16:11:20Z")
Other than the `a` formatter option you found, and the existing `b` formatter, your only other option is to set a fixed unit using TSVB. For example to convert to millions you can divide by 1000000 and then append the suffix "M". ---
**Author:** ![RamyaGowda](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/ramyagowda/32/27440_2.png) [@RamyaGowda](https://discuss.elastic.co/u/RamyaGowda)\ **Post date:** [December 22, 2020, 11:03am UTC](https://discuss.elastic.co/t/displaying-numbers-as-1m-1b-1k-in-kibana/259227/5 "2020-12-22T11:03:57Z")
Hi @wylie, Thanks for your response 🙂 but this doesn't solve the purpose. Let's say number of events in last 1 hour are 10000 , for the smaller granularity like 5mins to 1hour for an example 10000/1000000 = 0.01M is not very proper way of displaying metrics in a monitoring system. Is there any workaround for this apart from this method. Thanks, Ramya ---
**Author:** ![ylasri](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/ylasri/32/86120_2.png) [@ylasri](https://discuss.elastic.co/u/ylasri)\ **Post date:** [December 22, 2020, 11:32am UTC](https://discuss.elastic.co/t/displaying-numbers-as-1m-1b-1k-in-kibana/259227/6 "2020-12-22T11:32:11Z")
You still have an option to use Markdown in TSVB and apply a custom CSS to your metric ![image](https://us1.discourse-cdn.com/elastic/original/3X/2/5/2515cc9aec95aabfbd80aa019a85ba2bde7e2249.png) ![image](https://us1.discourse-cdn.com/elastic/original/3X/2/4/24b37dcb81d94aad54c5098b3c9a9cf1eac2bb9b.png) ![image](https://us1.discourse-cdn.com/elastic/original/3X/7/a/7a4ecc5b17a18230ebbf18f20205561831ea7abe.png) ---
**Author:** ![RamyaGowda](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/ramyagowda/32/27440_2.png) [@RamyaGowda](https://discuss.elastic.co/u/RamyaGowda)\ **Post date:** [December 22, 2020, 12:12pm UTC](https://discuss.elastic.co/t/displaying-numbers-as-1m-1b-1k-in-kibana/259227/7 "2020-12-22T12:12:37Z")
@ylasri, Your awesome, this trick worked for me 🙂 Thanks, Ramya ---
**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\ **Post date:** [January 19, 2021, 12:12pm UTC](https://discuss.elastic.co/t/displaying-numbers-as-1m-1b-1k-in-kibana/259227/8 "2021-01-19T12:12:47Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.