How can I create a Month & Year column to sort data by from separate month and year columns?

[DRing]

I have date data with my month and year like below. My problem is that my time series charts are all in the wrong order. 

I'm struggling to create a month and year format that will allow me to sort correctly. Any ideas?

[amitchandak · Accepted solution]

@DRing , You can create a new column like

Year month = [Year]*100 + [Month]

Year month Name = format(date([Year], [Month], 1), "MMM-YYYY")

If you want a second one, mark the first as a sort column for the first

How to Create Sort Column and Solve Related Errors:
https://www.youtube.com/watch?v=KK1zu4MBb-c

[lbendlin · Accepted solution]

Please read about ISO-8601.  The year MUST ALWAYS come first.  Ignore at your own peril.

[v-jiewu-msft · Accepted solution]

Hi @DRing ,

Please try the following methods and check if they can solve your problem:

1.Create the simple table.

2.Create the month and year column.

YearMonth = FORMAT('Date'[Date], "YYYY/MM")

3.Drag the column into the column chart visual.

4.The result is shown below.

[lbendlin · Accepted solution]

Please read about ISO-8601.  The year MUST ALWAYS come first.  Ignore at your own peril.

[amitchandak · Accepted solution]

@DRing , You can create a new column like

Year month = [Year]*100 + [Month]

Year month Name = format(date([Year], [Month], 1), "MMM-YYYY")

If you want a second one, mark the first as a sort column for the first

How to Create Sort Column and Solve Related Errors:
https://www.youtube.com/watch?v=KK1zu4MBb-c