Forum Discussion
Line Chart x axis label
I am trying to show the months/years as the data labels in my line chart. The data is formatted as a date. I can use the date hiearchy to only show month and year, however, it reads year month (e.g. 2023 February). I would like for it to read Feb. 23. How do I get it to read like that?
Thanks for the help.
2 Replies
Here's one way to do it. Add a calculated column to get the end of month (EOM) from your Date column. Then set the format string for that column to Mmm yy
Create your line chart. If you leave the X axis as Continuous the labels will auto adjust, but if you want it to look like your picture then set it to Categorical and adjust the chart size until it looks like this.
Pat
So I tried this solution, however, I am faced with an issue because I do not have the format type mmm yy in my format options. Shown below:
