# Format Large Numbers

**URL:** <https://community.grafana.com/t/format-large-numbers/117680>\
**Category:** Grafana\
**Tags:** format\
**Created:** [March 22, 2024, 4:07pm UTC](https://community.grafana.com/t/format-large-numbers/117680 "2024-03-22T16:07:25Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![rob.loh](https://avatars.discourse-cdn.com/v4/letter/r/f05b48/32.png) [@rob.loh](https://community.grafana.com/u/rob.loh)\
**Post date:** [March 22, 2024, 4:07pm UTC](https://community.grafana.com/t/format-large-numbers/117680/1 "2024-03-22T16:07:25Z")

</div>

I am working with German clients and need to display numbers the German way.

For example:

1024.5 should be displayed as 1.024,5  
1,000,000.00 should be displayed as 1.000.000,00

How can I achieve this?

Already tried:  
Unit → Misc → Locale format - did not work (displays e.g. 1,000.00)

This would not solve the problem for a percent anyway, as this is also a “Unit”. When percent is chosen I would lose the Locale format (should be 85,5%):

 ![image](https://us1.discourse-cdn.com/grafana/original/3X/2/6/26cebf35e7a850b86b138943bb7bbc3d2ca10092.png)

---

<div class="post-metadata">

**Author:** ![yosiasz](https://sea2.discourse-cdn.com/grafana/user_avatar/community.grafana.com/yosiasz/32/45847_2.png) [@yosiasz](https://community.grafana.com/u/yosiasz)\
**Post date:** [March 22, 2024, 5:17pm UTC](https://community.grafana.com/t/format-large-numbers/117680/2 "2024-03-22T17:17:18Z")

</div>

what is your data source? best to do it on data source

in mssql it is

 ![image](https://us1.discourse-cdn.com/grafana/original/3X/4/2/42e43f04a7b85cb5f3dac0f2fbab8059359eae1e.png)

---

<div class="post-metadata">

**Author:** ![rob.loh](https://avatars.discourse-cdn.com/v4/letter/r/f05b48/32.png) [@rob.loh](https://community.grafana.com/u/rob.loh)\
**Post date:** [March 25, 2024, 8:23am UTC](https://community.grafana.com/t/format-large-numbers/117680/3 "2024-03-25T08:23:08Z")

</div>

Postgres data source. I think formatting is usually done using to\_char() in postgres, however the Grafana visualizations want a number to be able to calculate e.g. the height of a bar or the fill of a gauge.

Is there maybe a backdoor way of providing the raw numeric for visualization, while giving the formatted string for display up front? Otherwise I’m not sure how to make this solution work…

---

<div class="post-metadata">

**Author:** ![codi639](https://avatars.discourse-cdn.com/v4/letter/c/ba9def/32.png) [@codi639](https://community.grafana.com/u/codi639)\
**Post date:** [March 25, 2024, 8:31am UTC](https://community.grafana.com/t/format-large-numbers/117680/4 "2024-03-25T08:31:57Z")

</div>

Hey @rob.loh,

I’m not gonna lie, not a lot of people want to use the European number format in informatics 😔… (I’m European). The informatics standard is to use the format `1234.56`. Anyway, if you find a solution, I’ll for sure keep it in mind!

Best regards

---

<div class="post-metadata">

**Author:** ![rob.loh](https://avatars.discourse-cdn.com/v4/letter/r/f05b48/32.png) [@rob.loh](https://community.grafana.com/u/rob.loh)\
**Post date:** [March 25, 2024, 9:19am UTC](https://community.grafana.com/t/format-large-numbers/117680/5 "2024-03-25T09:19:49Z")

</div>

Yep, I’ve noticed… Grafana is a tool for communicating data outside of the “informatics” community though. Seems like a reasonable feature for such a tool to have implemented properly.

Apparently this feature has been requested over 8 years ago: [Feature Request: decimal mark with comma and thousand separator with dot · Issue #4252 · grafana/grafana · GitHub](https://github.com/grafana/grafana/issues/4252)

Not sure what’s going on here. Also not sure how to explain to my boss that getting the numbers in the right format is so difficult…

---

<div class="post-metadata">

**Author:** ![codi639](https://avatars.discourse-cdn.com/v4/letter/c/ba9def/32.png) [@codi639](https://community.grafana.com/u/codi639)\
**Post date:** [March 25, 2024, 9:33am UTC](https://community.grafana.com/t/format-large-numbers/117680/6 "2024-03-25T09:33:10Z")

</div>

I mean, since Grafana is opensource, you can managed to achieve this by yourself with playing in the opensource… But this might take a little longer than your boss expect haha.

Also, a quite good argument to explain the problem could be to explain that European numbers standards format are not international numbers standards, and that’s totally out of your hands…

I strongly recommend you to open a new feature request, with a link to the last one (8 years is to far away I think).
