Showing results for 
Search instead for 
Did you mean: 

Sort by Column bug - Column that were sorted resets to default

Hello everyone,


After updating my power bi desktop version to April 2021 i noticed that my already sorted column "Month Name" sorted by "Month Nr" lost its setting.

I sort by the desired column again, and after that it was fine.

A few hours later, after working with this pbix file (built new pages, refresh data etc) i noticed that sorting was missing again.. I sort by "Month Nr", it works fine but i'm afraid it might happen again...


sorted table --> import storage mode

pbix file & dataset --> mixed storage mode (import & direct query) 


Does anyone know how to solve this issue?


Thank you,


Status: New
Community Support



The latest version works fine for me. You may recreate the report and try earlier versions from Power BI updates archive.