Forum Discussion
Sort Chronologically MMM-YY Date
Your sort column doesn't incorporate the year, so you need to do that. You could consider the approach in this article with custom date strings - https://www.sqlbi.com/articles/creating-a-simpler-and-chart-friendly-date-table-in-power-bi/
Or you can make another FORMAT column with YYYYMM to get the yearmonths in order, and use this new column as your sort column.
Regards,
Pat
Microsoft EmployeeYour sort column doesn't incorporate the year, so you need to do that. You could consider the approach in this article with custom date strings - https://www.sqlbi.com/articles/creating-a-simpler-and-chart-friendly-date-table-in-power-bi/
Or you can make another FORMAT column with YYYYMM to get the yearmonths in order, and use this new column as your sort column.
Regards,
Pat
How can iget like below screen shot