Forum Discussion

littlepatos2's avatar
littlepatos2
Regular Visitor
2 years ago
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...
  • Greg_Deckler's avatar
    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.