# Fix x-axis in Kibana 7.13.2
**URL:** https://discuss.elastic.co/t/fix-x-axis-in-kibana-7-13-2/277918
**Category:** Kibana
**Created:** [July 6, 2021, 7:13am UTC](https://discuss.elastic.co/t/fix-x-axis-in-kibana-7-13-2/277918 "2021-07-06T07:13:55Z")
**Posts on this page:** 12
**Page:** 1
### Author:  [@ANKITA\_SAHA](https://discuss.elastic.co/u/ANKITA_SAHA)
#### Post date: [July 6, 2021, 7:13am UTC](https://discuss.elastic.co/t/fix-x-axis-in-kibana-7-13-2/277918/1 "2021-07-06T07:13:55Z")
Hi i m new to kibana!
I want help in making the x-axis static. I have two columns "no.of errors" and "hours".
I have no.of errors in y-axis and in x-axis is hours . When i try to filter my data my x-axis gets filtered but i want to keep it as it is.
please help!!!
i use kibana 7.13.2.
---
### Author:  [@ghudgins](https://discuss.elastic.co/u/ghudgins)
#### Post date: [July 6, 2021, 12:42pm UTC](https://discuss.elastic.co/t/fix-x-axis-in-kibana-7-13-2/277918/2 "2021-07-06T12:42:23Z")
Are you asking that clicking on a visualization still filters the data but doesn't "zoom in" on the X axis to the value you clicked (an hour in your example)? A screenshot might help, if you don't mind sharing
---
### Author:  [@ANKITA\_SAHA](https://discuss.elastic.co/u/ANKITA_SAHA)
#### Post date: [July 6, 2021, 3:08pm UTC](https://discuss.elastic.co/t/fix-x-axis-in-kibana-7-13-2/277918/3 "2021-07-06T15:08:32Z")
---
### Author:  [@wylie](https://discuss.elastic.co/u/wylie)
#### Post date: [July 6, 2021, 3:29pm UTC](https://discuss.elastic.co/t/fix-x-axis-in-kibana-7-13-2/277918/4 "2021-07-06T15:29:03Z")
In order to get a static X-axis, you can:
- Use the `Filters` function where you define each bar manually
- Use the aggregation-based bar chart (not Lens) with a Histogram function with extended bounds
---
### Author:  [@ANKITA\_SAHA](https://discuss.elastic.co/u/ANKITA_SAHA)
#### Post date: [July 6, 2021, 5:09pm UTC](https://discuss.elastic.co/t/fix-x-axis-in-kibana-7-13-2/277918/5 "2021-07-06T17:09:37Z")
for histogram i need a number or number\_range but unfortunately i am unable to convert my 'hour' column from string to int.
If you can tell me a way to convert will be helpful!!
---
### Author:  [@wylie](https://discuss.elastic.co/u/wylie)
#### Post date: [July 6, 2021, 5:56pm UTC](https://discuss.elastic.co/t/fix-x-axis-in-kibana-7-13-2/277918/6 "2021-07-06T17:56:36Z")
You can create a runtime field to do type conversion.
---
### Author:  [@ANKITA\_SAHA](https://discuss.elastic.co/u/ANKITA_SAHA)
#### Post date: [July 7, 2021, 7:30am UTC](https://discuss.elastic.co/t/fix-x-axis-in-kibana-7-13-2/277918/8 "2021-07-07T07:30:49Z")
i tried to ingest pipeline but getting error like
"type" : "number\_format\_exception", "reason" : "for input string: "hour""
---
### Author:  [@ghudgins](https://discuss.elastic.co/u/ghudgins)
#### Post date: [July 7, 2021, 1:10pm UTC](https://discuss.elastic.co/t/fix-x-axis-in-kibana-7-13-2/277918/9 "2021-07-07T13:10:35Z")
Check out runtime fields in the Lens UI instead of stack management (it's newer as of 7.13) - [Lens | Kibana Guide [7.13] | Elastic](https://www.elastic.co/guide/en/kibana/current/lens.html#add-fields-in-lens)
You can add a script that converts the field to the appropriate data type. Really, though, if this works for you it's more performant to index the appropriate type up front (runtime fields are slower than indexed fields).
Here's an example that does the opposite of what you're trying to do. The example uses painless which exposes a lot of useful java APIs.
```auto
Long input = doc['event.duration'].value;
String output = Objects.toString(input);
emit(output);
```
---
### Author:  [@ANKITA\_SAHA](https://discuss.elastic.co/u/ANKITA_SAHA)
#### Post date: [July 7, 2021, 5:10pm UTC](https://discuss.elastic.co/t/fix-x-axis-in-kibana-7-13-2/277918/11 "2021-07-07T17:10:48Z")
Thanks the conversion is done successfully 😀
---
### Author:  [@ANKITA\_SAHA](https://discuss.elastic.co/u/ANKITA_SAHA)
#### Post date: [July 7, 2021, 5:14pm UTC](https://discuss.elastic.co/t/fix-x-axis-in-kibana-7-13-2/277918/12 "2021-07-07T17:14:12Z")
I tried histogram but same thing its zooming in and not static
---
### Author:  [@ANKITA\_SAHA](https://discuss.elastic.co/u/ANKITA_SAHA)
#### Post date: [July 7, 2021, 5:28pm UTC](https://discuss.elastic.co/t/fix-x-axis-in-kibana-7-13-2/277918/13 "2021-07-07T17:28:04Z")
These are my settings! Here 'new' is the new field containing hours.
In the main dashboard when i apply filters it gets zoomed again which i dont want. I want all marks of x-axis
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [August 4, 2021, 5:28pm UTC](https://discuss.elastic.co/t/fix-x-axis-in-kibana-7-13-2/277918/14 "2021-08-04T17:28:45Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.