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
- xixo221 on: Expression.Error: We cannot apply operator & to ty...
-
v-xiaoyan-msft
on:
Aplicativo Power bi desktop nao abre
-
v-xiaoyan-msft
on:
Issue: OData feed no longer supports Query Folding
-
RossEdwards
on:
Setting "Stepped" as False in a theme file for Mat...
-
v-yetao1-msft
on:
Powerbi Direct Query and Cached Data issue
-
v-xiaoyan-msft
on:
Field parameters - Default sorting order resets Wh...
-
v-xiaoyan-msft
on:
Metric processing failed. Activity Id
-
v-xiaoyan-msft
on:
Issues updating SSL off-prem
- wemersontm on: Error on total column
-
v-yetao1-msft
on:
PowerBI Service - filter by keyword doens't bring ...
Hi @mtvent
Can you provide the column you created? You mentioned that the only solution is restart the PBI Desktop , meaning that after restarting, you can sort by the column you created?
Best Regards,
Community Support Team _ Ailsa Tao