Published report changes sort order from Desktop

[MarkusEng1998]

I have a report comparing room spaces between two buildings. The report is in Metric, and I created a duplicate tab with Imperial units. On the PowerBI Desktop, the Metric and Imperial reports look identical, i.e. the sort order is by room name.

But, when I publish the report, the Imperial sorts by room area. The sort order changes from the Desktop version.

This is driving me crazy. What am I missing?

[MarkusEng1998]

Was I supposed to clear the PowerBI cache or the Browser cache? I cleared both. Nevertheless, thank you very much for the timely solution! 😊

[amitchandak · Accepted solution]

@MarkusEng1998 , Th first thing you can do on this is clear cache and check.

Or republish, clear cache, and check.