# Show months on X-Axis while maintaining daily granularity of data **URL:** \ **Category:** Kibana\ **Created:** [October 11, 2018, 12:45pm UTC](https://discuss.elastic.co/t/show-months-on-x-axis-while-maintaining-daily-granularity-of-data/152051 "2018-10-11T12:45:21Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![Kult](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/kult/32/36877_2.png) [@Kult](https://discuss.elastic.co/u/Kult)\ **Post date:** [October 11, 2018, 12:45pm UTC](https://discuss.elastic.co/t/show-months-on-x-axis-while-maintaining-daily-granularity-of-data/152051/1 "2018-10-11T12:45:21Z")
Hi, I have a Kibana visualisation that represents disk capacity utilisation on a few servers. New data gets ingested daily, and should go a few months back on the visualisation. This is what it currently looks like: ![image](https://us1.discourse-cdn.com/elastic/original/3X/8/5/85fdf1f3b47afe48c878de9e1ab4544b6533fb68.png) Is there any way to make the graphs look exactly the same, but have month names instead of numerical dates? ![image](https://us1.discourse-cdn.com/elastic/original/3X/4/a/4a727b881fa43645fb521baac62fb2724525337e.png) (created with Paint) Best regards, Kult. ---
**Author:** ![bhavyarm](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/bhavyarm/32/22392_2.png) [@bhavyarm](https://discuss.elastic.co/u/bhavyarm)\ **Post date:** [October 11, 2018, 12:55pm UTC](https://discuss.elastic.co/t/show-months-on-x-axis-while-maintaining-daily-granularity-of-data/152051/2 "2018-10-11T12:55:19Z")
Hi, You can change the format of the field under field formatters and choose to display what you would like as axes values. ![14%20AM](https://us1.discourse-cdn.com/elastic/original/3X/6/4/64c7dfcce9b9ab4964b1fbc9640183dd5de8917a.jpeg) You can also use scripted fields to make date to display as month. But this would be a slightly expensive operation. Thanks, Bhavya ---
**Author:** ![Kult](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/kult/32/36877_2.png) [@Kult](https://discuss.elastic.co/u/Kult)\ **Post date:** [October 11, 2018, 1:09pm UTC](https://discuss.elastic.co/t/show-months-on-x-axis-while-maintaining-daily-granularity-of-data/152051/3 "2018-10-11T13:09:14Z")
Hi Bhavya, Thanks for the swift reply! Do you mean I should set format to "Date" and set "MMMM" for the moment.js format? ![image](https://us1.discourse-cdn.com/elastic/original/3X/c/3/c340cdabc3f0b28d4063e17db55aab59b72e3bcc.png) I've done that, but it appears to have no effect on the visualisation. Best regards, Kult. ---
**Author:** ![jen-huang](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/jen-huang/32/74327_2.png) [@jen-huang](https://discuss.elastic.co/u/jen-huang)\ **Post date:** [October 11, 2018, 2:28pm UTC](https://discuss.elastic.co/t/show-months-on-x-axis-while-maintaining-daily-granularity-of-data/152051/4 "2018-10-11T14:28:38Z")
Hi, you will actually need to set this in **Scaled date format** in Management \> Advanced Settings: ![image](https://us1.discourse-cdn.com/elastic/original/3X/7/0/70708580465245ffa51418f110b7c165bb1cfc04.png) The reason is that this allows for more granular control of formatting. For example, for intervals less than week, it makes sense format them as weekdays instead of months. ---
**Author:** ![Kult](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/kult/32/36877_2.png) [@Kult](https://discuss.elastic.co/u/Kult)\ **Post date:** [October 11, 2018, 3:00pm UTC](https://discuss.elastic.co/t/show-months-on-x-axis-while-maintaining-daily-granularity-of-data/152051/5 "2018-10-11T15:00:02Z")
Hi jen-huang, As a test for trying to understand what that setting really does, I've left it unchanged, went back to my index pattern's @timestamp and changed moment.js format pattern to be "YYYY-MM-DD" (as it is one of the predefined ones in dateFormate:scaled). After that, I went back to the visualisation, but unfortunately I saw no changes. The only place I see the pattern change some behaviour is in Discovery. ![image](https://us1.discourse-cdn.com/elastic/original/3X/3/a/3a8e5d9b189f46d69de2718116fbda45f5c20525.png) ![image](https://us1.discourse-cdn.com/elastic/original/3X/e/c/ec740164f4578e1c2b5c8a82df87d97de4fa0f39.png) ![image](https://us1.discourse-cdn.com/elastic/original/3X/1/5/15de829e4562add77e68b5b10b8a15e6ee29a8b9.png) I'd expect all those 00:00 to be dropped from the graph after I made the change. What am I missing here? Best regards, Kult. ---
**Author:** ![Kult](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/kult/32/36877_2.png) [@Kult](https://discuss.elastic.co/u/Kult)\ **Post date:** [October 11, 2018, 3:34pm UTC](https://discuss.elastic.co/t/show-months-on-x-axis-while-maintaining-daily-granularity-of-data/152051/6 "2018-10-11T15:34:22Z")
Just realised that I had to change Interval to "Monthly" to make the thing effective. Works fine now. Cheers! ---
**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\ **Post date:** [November 8, 2018, 3:34pm UTC](https://discuss.elastic.co/t/show-months-on-x-axis-while-maintaining-daily-granularity-of-data/152051/7 "2018-11-08T15:34:23Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.