Sort Month and Year in Chronological order

Create a sort column and mark it as sort column

Sort moth year = format(date[date],"YYYYMM")

Appreciate your Kudos.

Hi Anonymous ,

After creating the sort column, did you do this operation?

After sorting by YearMonth column, Month & Year column will sort correctly in your visual.

Best Regards,

Icey

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

Anonymous ,

I hope you created the column in the same table. And you have to click on the column you want to change sort order. ie the old month year. I have given screenshot where is sort option. In new ribbon, it is under column properties.

Also make sure visual is sorted on month year(the column which you have used in visual)

OLD

NEW

Appreciate your Kudos.