# Formatting x-axis as percentage

**URL:** <https://discuss.elastic.co/t/formatting-x-axis-as-percentage/222722>\
**Category:** Kibana\
**Tags:** canvas\
**Created:** [March 9, 2020, 2:10pm UTC](https://discuss.elastic.co/t/formatting-x-axis-as-percentage/222722 "2020-03-09T14:10:57Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![J\_Weeda](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/j_weeda/32/45092_2.png) [@J\_Weeda](https://discuss.elastic.co/u/J_Weeda)\
**Post date:** [March 9, 2020, 2:10pm UTC](https://discuss.elastic.co/t/formatting-x-axis-as-percentage/222722/1 "2020-03-09T14:10:57Z")

</div>

hi,

I'm trying to create a canvas with a horizontal bar chart with a percentage (0.0 - 1.0) on the x-axis but can't get it sorted. What syntax do i need to add? Currently the chart shows 0.00 through 1.00 on the x-axis.

```
filters

| essql

query="SELECT \"metric.instance\" as \"Object\", AVG(\"metric.value_double\") as \"Availability\" FROM \"filebeat-7.4.1" GROUP BY \"metric.instance\" "

| pointseries x="mean(Availability)" y="Object" color="project"

| plot defaultStyle={seriesStyle bars=0.75 horizontalBars=true color="#004170"} legend=false

| render
```

---

<div class="post-metadata">

**Author:** ![corey.robertson](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/corey.robertson/32/54611_2.png) [@corey.robertson](https://discuss.elastic.co/u/corey.robertson)\
**Post date:** [March 12, 2020, 6:15pm UTC](https://discuss.elastic.co/t/formatting-x-axis-as-percentage/222722/2 "2020-03-12T18:15:10Z")

</div>

Hi @J_Weeda

Can you share what the bar chart you are getting looks like? It should be sorted correctly by default, so I'm curious what may be happening here.

---

<div class="post-metadata">

**Author:** ![J\_Weeda](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/j_weeda/32/45092_2.png) [@J\_Weeda](https://discuss.elastic.co/u/J_Weeda)\
**Post date:** [March 12, 2020, 6:29pm UTC](https://discuss.elastic.co/t/formatting-x-axis-as-percentage/222722/3 "2020-03-12T18:29:25Z")

</div>

Hi @corey.robertson, thanks for your response. There is no sorting issue. I would like to format the axis as percentage (100% rather than 1.0)

---

<div class="post-metadata">

**Author:** ![corey.robertson](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/corey.robertson/32/54611_2.png) [@corey.robertson](https://discuss.elastic.co/u/corey.robertson)\
**Post date:** [March 12, 2020, 8:32pm UTC](https://discuss.elastic.co/t/formatting-x-axis-as-percentage/222722/4 "2020-03-12T20:32:52Z")

</div>

@J_Weeda oh I see.

Unfortunately, there is not a way to format the display of the axis. We've had several asks for this and have an issue to track it if you want to follow along [https://github.com/elastic/kibana/issues/44325](https://github.com/elastic/kibana/issues/44325)

---

<div class="post-metadata">

**Author:** ![J\_Weeda](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/j_weeda/32/45092_2.png) [@J\_Weeda](https://discuss.elastic.co/u/J_Weeda)\
**Post date:** [March 12, 2020, 8:47pm UTC](https://discuss.elastic.co/t/formatting-x-axis-as-percentage/222722/5 "2020-03-12T20:47:09Z")

</div>

Thanks @corey.robertson, I'll track the mentioned issue.

---

<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:** [April 9, 2020, 8:47pm UTC](https://discuss.elastic.co/t/formatting-x-axis-as-percentage/222722/6 "2020-04-09T20:47:10Z")

</div>

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