Forum Discussion
Year Month Ordering
Hello,
How do I put these in order?
I have created a dates table, created this month year column, now I want to show all date, have a continuous x axis and want the order to be correct. I have read numerous blog posts but can't find the answer. I have tried sort etc, but as the month year is text it is not recognised. I have tried to go to the data and use sort order by column, and changed this to numbers - but no luck.
Please help.
Sam7 , You need sort column
Month Year = FORMAT([Date],"mmm-yyyy")
Month Year sort = FORMAT([Date],"yyyymm")https://docs.microsoft.com/en-us/power-bi/desktop-sort-by-column
2 Replies
Sam7 , You need sort column
Month Year = FORMAT([Date],"mmm-yyyy")
Month Year sort = FORMAT([Date],"yyyymm")https://docs.microsoft.com/en-us/power-bi/desktop-sort-by-column
Thanks!
