Sort by Month - Year

Hi Samruddhi_11 

Change the date format to whole number will better you sort the Month – Year .

(1)Make sure the Month-Year column is in Date format . If not ,change it to Date format .

(2)Create a column to return the whole number format for the Month-Year column .

Year-Month = YEAR('Table'[Date])*100+'Table'[Date].[MonthNo]

(3)Create a column to return the Text format for the Month-Year column .

month year = FORMAT('Table'[Date],"MMMM") & YEAR('Table'[Date])

(4)Select the visual ,and Sort by Year-Month , then choose Sort ascending .

The final result is as shown :

I have attached my pbix file , you can refer to it .

Best Regards

Community Support Team _ Ailsa Tao

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