Get certified for free when you join Fabric Data Days 2026 and dive into Fabric, Power BI, SQL, AI, and other essential data skills.
Join nowJuly 28 - August 9 | Final Round of the Power BI Dataviz World Championships. This is your chance. Learn more
This has now happened with two different reports, completely different data sources. I have a column with date, and use Power Query to add a Month Name and Month (number) column. Then, I try to sort the month name by the number, but I receive this error message:
I tried so many potential solutions, including checking my data over and over and using a custom or conditional column instead of extracting the month. but saving the report and restarting PBI desktop has been the only functioning solution.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.