Forum Discussion
Solved
Unable to sort by date rather than value
The community is a life saver to me as I teach myself Power BI. Thanks for all the support. I have created a date table that includes date, date as integer, and YearMonthName. I have a clustere...
Can't you just switch the Sort by column for YearMonthShort to the YearMonthNumber column?
Hi
When you click on the Top right corner of visual ->sort by -> select the date , what happens?
Changing Sort to YearMonth, and then sort ascending gives me following. I still cannot get the months to sort in ascending order
Please refer this post and you can follow the same steps.
https://community.powerbi.com/t5/Desktop/Month-Name-in-sorting-order-in-Direct-Query/td-p/204269
Thanks
Raj
