Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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.
Solved! Go to Solution.
@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!
@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