# Kibana 6.3 - How to display the formatted value on Y-Axis? **URL:** \ **Category:** Kibana\ **Created:** [May 17, 2019, 1:31pm UTC](https://discuss.elastic.co/t/kibana-6-3-how-to-display-the-formatted-value-on-y-axis/181600 "2019-05-17T13:31:21Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![AlexCharb](https://avatars.discourse-cdn.com/v4/letter/a/58956e/32.png) [@AlexCharb](https://discuss.elastic.co/u/AlexCharb)\ **Post date:** [May 17, 2019, 1:31pm UTC](https://discuss.elastic.co/t/kibana-6-3-how-to-display-the-formatted-value-on-y-axis/181600/1 "2019-05-17T13:31:21Z")
Hello, I have an input wich is a number field, I formatted it on Kibana index Management as a microseconds duration displayed as a seconds duration with 3 decimals as follow: ![image](https://us1.discourse-cdn.com/elastic/original/3X/d/6/d6fd8061d4e19e340013ebd9337dc0add3a1839e.png) However, when I use this value on a chart as Y-Axis value, it doesn't display as the formatted value I set it and it makes it inconsistent: ![Sans%20titre](https://us1.discourse-cdn.com/elastic/original/3X/a/b/ab90204dd8dfdf632a2e1ade539263aef740a070.png) Any idea how to fix this ? Thank you Alex ---
**Author:** ![markov00](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/markov00/32/33316_2.png) [@markov00](https://discuss.elastic.co/u/markov00)\ **Post date:** [May 24, 2019, 1:08pm UTC](https://discuss.elastic.co/t/kibana-6-3-how-to-display-the-formatted-value-on-y-axis/181600/2 "2019-05-24T13:08:04Z")
Hi @AlexCharb thanks for your question. Can you please specify your Kibana version? I've seen that we have few bugs going around related to Duration formatter, I've seen also that reordering the metrics can solve the axis problem: try to rearrange the mertics moving the Average atmicro one as the first in the list. Related bug: > ---
**Author:** ![AlexCharb](https://avatars.discourse-cdn.com/v4/letter/a/58956e/32.png) [@AlexCharb](https://discuss.elastic.co/u/AlexCharb)\ **Post date:** [May 24, 2019, 1:31pm UTC](https://discuss.elastic.co/t/kibana-6-3-how-to-display-the-formatted-value-on-y-axis/181600/3 "2019-05-24T13:31:44Z")
Hi @markov00 My Kibana version is 6.3.2. I tried switching the metrics, then it goes well for my duration value but it messes with my other metric. So I think it is more about a 2nd metric matter more than format issues. Here an example of what it does when I put my count agg at 2nd place: ![2metricdisplaysissue](https://us1.discourse-cdn.com/elastic/original/3X/5/6/565a873ed861c77be6be475390b1675c3445c963.png) ---
**Author:** ![markov00](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/markov00/32/33316_2.png) [@markov00](https://discuss.elastic.co/u/markov00)\ **Post date:** [May 24, 2019, 3:00pm UTC](https://discuss.elastic.co/t/kibana-6-3-how-to-display-the-formatted-value-on-y-axis/181600/4 "2019-05-24T15:00:55Z")
Hi Alex, yes, unfortunately that's exactly the bug specified in the github issue before. Have you tried to use Visual Builder for that? I think you can add multiple series, specify "separate axis" for one series and you can specify the duration format on the option panel (from ms to seconds with 3 decimal places). I've run a test on my 6.3 version and seems to correctly handle that ---
**Author:** ![AlexCharb](https://avatars.discourse-cdn.com/v4/letter/a/58956e/32.png) [@AlexCharb](https://discuss.elastic.co/u/AlexCharb)\ **Post date:** [May 24, 2019, 3:17pm UTC](https://discuss.elastic.co/t/kibana-6-3-how-to-display-the-formatted-value-on-y-axis/181600/5 "2019-05-24T15:17:41Z")
Hi Marco, Indeed Visual Builder makes it very well ! I will work with time series waiting for the bar chart panel to handle it 🙂 Thanks ---
**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\ **Post date:** [June 21, 2019, 3:17pm UTC](https://discuss.elastic.co/t/kibana-6-3-how-to-display-the-formatted-value-on-y-axis/181600/6 "2019-06-21T15:17:43Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.