Dates (months) out of chronological order on x-axis of chart

[lh2023]

Hello,

I have a question regarding the order of dates along the x-axis of a chart created in power BI. I am showing the change in a feature for the last 6 months  (Sept 2022 - March 2023).. I would prefer to see the most current date as the rightmost value on the x-axis (in the case of a trend in the time series, rearranging these dates has a great influence on the appearance of the line chart); however,  Power BI seems to default list the month names in cxhronological order, disregarding the year. If I list the 'year' first, then only the year shows, without division by month. Does anyone know how to place the months in chronological order by year?

For reference: 

the above image shows the x-axis when 'month name' and 'calendar year' are separately defining the x-axis as shown below:

 When combining the year and month hierarchically, the x-axis looks as follows (disregards the separate months):

Any suggestions would be greatly appreciated. Thank you! 🙂 

[jony_gloeckner]

Hi @lh2023 ,

you need to create another column with numerical values for your Month name column and sort Month name column by another column.

You can read more about procedure here:
https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-sort-by-column?tabs=powerbi-deskto...