Forum Discussion
JimB-GA
Helper III
Helper IIIUnable 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?
JimB-GAHelper III
Helper IIIChanging 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
- parry2k
Super User
- JimB-GA
I changed sort order. The previous graph illustrates setting for ascending order. Here is what descending order looks like:
adambhappyResolver II
Can't you just switch the Sort by column for YearMonthShort to the YearMonthNumber column?
