Forum Discussion
Solved
Sorting Years and Months in Line Chart
I have a dataset with 2 years of retail transactions and the data includes Month and Year columnhs. I am trying to create a line chart to show decline in total cost over years and months but i can't...
littlepatos2 You will need a numeric Sort By column for your Month, something like MONTH('Table'[Date]) and then set that as your Sort By column for your alphanumeric month name column.
In your semantic model, create a column that creates the correct sort order. For example, 2401 for January 2024, 2402 for February 2024, etc.... Then use that field instead for your X axis.