Forum Discussion
littlepatos2
2 years agoRegular Visitor
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...
- 2 years ago
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.
Greg_Deckler
2 years agoCommunity Champion
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.