# Fractional Unit Representation on visualization in Kibana **URL:** \ **Category:** Kibana\ **Created:** [April 16, 2018, 11:29am UTC](https://discuss.elastic.co/t/fractional-unit-representation-on-visualization-in-kibana/128179 "2018-04-16T11:29:27Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![vincent25](https://avatars.discourse-cdn.com/v4/letter/v/71c47a/32.png) [@vincent25](https://discuss.elastic.co/u/vincent25)\ **Post date:** [April 16, 2018, 11:29am UTC](https://discuss.elastic.co/t/fractional-unit-representation-on-visualization-in-kibana/128179/1 "2018-04-16T11:29:27Z")
Hi, Is there any way to remove the fractional unit representation from any axis(e.g Y axis in my case) in Kibana visualization? I need to remove these fractional values(.5,1.5,2.5 etc.) from the Y Axis while representing my event counts. Attaching herewith a screenshot of Kibana Bar Chart visualization for reference. Thanks. ![Y%20Axis](https://us1.discourse-cdn.com/elastic/original/3X/e/c/ec3531a470b9377a6698988b62e6260bfa1130eb.jpg) ---
**Author:** ![Bill\_McConaghy](https://avatars.discourse-cdn.com/v4/letter/b/ed655f/32.png) [@Bill\_McConaghy](https://discuss.elastic.co/u/Bill_McConaghy)\ **Post date:** [April 16, 2018, 1:18pm UTC](https://discuss.elastic.co/t/fractional-unit-representation-on-visualization-in-kibana/128179/2 "2018-04-16T13:18:21Z")
A field formatter of type number, format number and format of `0,0` will do the trick. Note that this just lops off the decimal portion and does not round. If you want rounding, you will need to use a scripted field. ---
**Author:** ![vincent25](https://avatars.discourse-cdn.com/v4/letter/v/71c47a/32.png) [@vincent25](https://discuss.elastic.co/u/vincent25)\ **Post date:** [April 17, 2018, 6:20am UTC](https://discuss.elastic.co/t/fractional-unit-representation-on-visualization-in-kibana/128179/3 "2018-04-17T06:20:29Z")
Hi Bill, Thanks for your reply.Can you elaborate a little on the solution?How will I achieve it ?Do I have to change settings in Kibana GUI only or elsewhere too? Regards. ---
**Author:** ![Bill\_McConaghy](https://avatars.discourse-cdn.com/v4/letter/b/ed655f/32.png) [@Bill\_McConaghy](https://discuss.elastic.co/u/Bill_McConaghy)\ **Post date:** [April 17, 2018, 11:28am UTC](https://discuss.elastic.co/t/fractional-unit-representation-on-visualization-in-kibana/128179/4 "2018-04-17T11:28:01Z")
This change can be made in the Kibana GUI. Go to Management (tab on left) \> Index Patterns \> { your index pattern} \> find the the field you want to format and click the pencil at the right of its column (it will show up when you hover over there). You can enter the formatter config there. ---
**Author:** ![vincent25](https://avatars.discourse-cdn.com/v4/letter/v/71c47a/32.png) [@vincent25](https://discuss.elastic.co/u/vincent25)\ **Post date:** [April 19, 2018, 10:56am UTC](https://discuss.elastic.co/t/fractional-unit-representation-on-visualization-in-kibana/128179/5 "2018-04-19T10:56:42Z")
Hi Bill, Thanks,I have achieved something as shown below after changing the format as suggested by you.I am using Kibana 5.5 and the setting is available under Management\>Advanced Settings. ![Screenshot-2018-4-19](https://us1.discourse-cdn.com/elastic/original/3X/d/8/d81ae4c2d4fdc041ae21b3237c2aea8d5621c6af.png) Now my understanding is that this representation is erroneous and creates confusion and if I even use scripted field to round off the decimal portion it will still be a erroneous and confusing representation(e.g. 1.8 will be rounded off to 2 and 1.2 to 1 considering two decimal places) Is my understanding correct? Regards. ---
**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\ **Post date:** [May 17, 2018, 10:57am UTC](https://discuss.elastic.co/t/fractional-unit-representation-on-visualization-in-kibana/128179/6 "2018-05-17T10:57:05Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.