Sorting Year and Month in Data and also in Graph

[kalyani]

I'm trying to sort my data with the Month as 01 02 03...11 12, so that my other column YearMonth , gets sorted accordingly. But both the fields are text and it is not sorting in the right order.

1) Even if I change the field to Whole number and sort, it is not changing the sorting values.

2) Once, this is sorted, In the graph, I have to bring the order as recent 6 months, like the axis value should arrange from 201711 201712 201801 201802 201803..

Can someone help me to fix this

[v-chuncz-msft · Accepted solution]

@kalyani,

You may sort by [YearMonth] or add a calculated column.

Column =
DATE ( Table1[Year], Table1[MonthNo], 1 )