Forum Discussion
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 clustered column visual tbat shows the count of records each month. Unfortunately it sorts by the value field and not by the Axis (yearMonthName)
I have tried to use 'sort by column ' and select date but receive a 'sort by another column' message saying there can't be more than one value in the 'Date' field for the same value in "YearMonth".
Can't you just switch the Sort by column for YearMonthShort to the YearMonthNumber column?
8 Replies
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
