# Prevent grafana rounding values

**URL:** <https://community.grafana.com/t/prevent-grafana-rounding-values/25558>\
**Category:** Time Series Panel\
**Tags:** time-series-panel, templating, mysql, dashboard, alert-templating\
**Created:** [February 4, 2020, 5:08pm UTC](https://community.grafana.com/t/prevent-grafana-rounding-values/25558 "2020-02-04T17:08:41Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![tmdag](https://sea2.discourse-cdn.com/grafana/user_avatar/community.grafana.com/tmdag/32/9376_2.png) [@tmdag](https://community.grafana.com/u/tmdag)\
**Post date:** [February 4, 2020, 5:08pm UTC](https://community.grafana.com/t/prevent-grafana-rounding-values/25558/1 "2020-02-04T17:08:42Z")

</div>

Hi,

I have timed data on Mysql with values in thousents that I set to “Currency/ Dolars ($)”.  
Grafana for some reason, instead of displaying precise values of those values in Y access like  
“$1100” or “$2500” it just displays “$1K”, “$2K”.

A graph that goes from bottom to top “2K,2K,2K,2K,3K,3K” is not very helpful. How can I enforce some precission and get at least “2100, 2200, 2300, 2400” etc.

---

<div class="post-metadata">

**Author:** ![malamgir](https://sea2.discourse-cdn.com/grafana/user_avatar/community.grafana.com/malamgir/32/9479_2.png) [@malamgir](https://community.grafana.com/u/malamgir)\
**Post date:** [February 4, 2020, 5:22pm UTC](https://community.grafana.com/t/prevent-grafana-rounding-values/25558/2 "2020-02-04T17:22:36Z")

</div>

Go to visualization style and change the unit of Y axis. By default its short . change unit from short to none.

---

<div class="post-metadata">

**Author:** ![tmdag](https://sea2.discourse-cdn.com/grafana/user_avatar/community.grafana.com/tmdag/32/9376_2.png) [@tmdag](https://community.grafana.com/u/tmdag)\
**Post date:** [February 5, 2020, 9:45am UTC](https://community.grafana.com/t/prevent-grafana-rounding-values/25558/3 "2020-02-05T09:45:17Z")

</div>

I have it set to “Currency / Dollars ($)” and I would like to keep it as $

---

<div class="post-metadata">

**Author:** ![Ventureboy2000](https://avatars.discourse-cdn.com/v4/letter/v/50afbb/32.png) [@Ventureboy2000](https://community.grafana.com/u/Ventureboy2000)\
**Post date:** [January 28, 2022, 7:16am UTC](https://community.grafana.com/t/prevent-grafana-rounding-values/25558/4 "2022-01-28T07:16:07Z")

</div>

Hello,

in my case changing “Unit” to String disabled rounding

---

<div class="post-metadata">

**Author:** ![grant2](https://sea2.discourse-cdn.com/grafana/user_avatar/community.grafana.com/grant2/32/42281_2.png) [@grant2](https://community.grafana.com/u/grant2)\
**Post date:** [January 28, 2022, 11:57am UTC](https://community.grafana.com/t/prevent-grafana-rounding-values/25558/5 "2022-01-28T11:57:16Z")

</div>

Even though the original post by @tmdag is almost 2 years old, in case anyone is still wondering…

 ![image](https://us1.discourse-cdn.com/grafana/original/3X/1/2/12109e807708b41948588109e564d57df2a183bc.png)

---

<div class="post-metadata">

**Author:** ![niyantaz](https://avatars.discourse-cdn.com/v4/letter/n/34f0e0/32.png) [@niyantaz](https://community.grafana.com/u/niyantaz)\
**Post date:** [February 16, 2023, 10:27am UTC](https://community.grafana.com/t/prevent-grafana-rounding-values/25558/6 "2023-02-16T10:27:29Z")

</div>

how to do this in Alerting?

---

<div class="post-metadata">

**Author:** ![grant2](https://sea2.discourse-cdn.com/grafana/user_avatar/community.grafana.com/grant2/32/42281_2.png) [@grant2](https://community.grafana.com/u/grant2)\
**Post date:** [February 16, 2023, 1:47pm UTC](https://community.grafana.com/t/prevent-grafana-rounding-values/25558/7 "2023-02-16T13:47:11Z")

</div>

To display only 2 digits to the right of the decimal, try using something like this in your alert template:

`{{ printf "%.2f" $values.D.Value }}`