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.
Comments