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

[aandreou]

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,

Artemis

[v-chuncz-msft]

@aandreou 

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