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...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    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.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi littlepatos2 ,

First of all, many thanks to  for your very quick and effective replies.

I can't open the link.

Based on my testing, please try the following methods:

1.Create the simple table.

2.Select the Date column and choose the sort by values column.

3.The result is shown below.

Best Regards,

Wisdom Wu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.