Forum Discussion
Line Chart Months on Axis
Hello Fellow Power BI Users,
I have a line chart with a date on the X Axis as shown below. The months July-December (2016) display in the correct sequence along the X-Axis. However, January (2017) is showing to the left of August.
Do any of you know how I may cause January to appear after December?
Thank you,
Michael
Is your X axis month name or actual dates? If it is just month name, you will need to make some kind of month-year key to put on the X axis. If you are more interested in reording (i.e. for a fiscal year Feb-Jan), then you need to make a Month Order column in your data that you can sort Month Name by.
1 Reply
Is your X axis month name or actual dates? If it is just month name, you will need to make some kind of month-year key to put on the X axis. If you are more interested in reording (i.e. for a fiscal year Feb-Jan), then you need to make a Month Order column in your data that you can sort Month Name by.