# Data Formatter in TSVB visualization

**URL:** https://discuss.elastic.co/t/data-formatter-in-tsvb-visualization/245982
**Category:** Kibana
**Created:** [August 22, 2020, 10:46am UTC](https://discuss.elastic.co/t/data-formatter-in-tsvb-visualization/245982 "2020-08-22T10:46:44Z")
**Posts on this page:** 3
**Page:** 1

<div class="post-metadata">

### Author: ![hiba](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/hiba/32/110919_2.png) [@hiba](https://discuss.elastic.co/u/hiba)
#### Post date: [August 22, 2020, 10:46am UTC](https://discuss.elastic.co/t/data-formatter-in-tsvb-visualization/245982/1 "2020-08-22T10:46:45Z")

</div>

Hi ,

i use kibana 7.7.0.

i create a TSVB visualization :  
X-axis: sum of credit and sum of debit  
Y-axis: date per day .

in my index the fields "credit" and "debit" are a number with a format string.  
i like to display the sum of credit and debit with a format like 3200 instead of 3,200.

 ![elk](https://us1.discourse-cdn.com/elastic/original/3X/0/c/0cc8cf56ef2b18b8ee98b326f6926c0bda01d00c.png)

any help please

---

<div class="post-metadata">

### Author: ![stephenb](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/stephenb/32/40856_2.png) [@stephenb](https://discuss.elastic.co/u/stephenb)
#### Post date: [August 22, 2020, 2:14pm UTC](https://discuss.elastic.co/t/data-formatter-in-tsvb-visualization/245982/2 "2020-08-22T14:14:09Z")

</div>

@hiba

Yup you can do that.

Navigate to to the Data -\> Option Tab and Select Custom Formats in the Data Formatter and put in the format you like. In this case it is the most basic number format `0`. You can look at other formats by clicking the Numeral.js link. There are currency formats as well etc..

 ![Screen Shot 2020-08-22 at 7.10.15 AM](https://us1.discourse-cdn.com/elastic/original/3X/c/1/c17baa30c20b6fb769c5e2c7a4659bdd9da4d1a7.png)

---

<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: [September 19, 2020, 2:14pm UTC](https://discuss.elastic.co/t/data-formatter-in-tsvb-visualization/245982/3 "2020-09-19T14:14:25Z")

</div>

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