Forum Discussion
Michael1
Advocate II
Advocate IILine 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 (20...
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.
dkay84_PowerBI
Microsoft Employee
Microsoft EmployeeIs 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.