sort order of umlauted characters

[Anonymous]

Despite having correct regional settings, the sorting order of"å", "ä"  and "ö" (Swedish) is wrong. In Scandinavian languages, these characters are not accents but separete ones and should be sorted at the end of the alphabet. 

They should sort as "...xyzåäö".

This is done correctly in Office.

Using the Swedish version of PowerBi Desktop gives the correct sorting, but few desoigners will do that since almost all documentations is in English,

[alepp]

Hi, I am encountering the same issue for the first time now. I have a list of municipalities and when I want to use the list in a slicer, the list order is:

Äänekoski

Ähtäri

Akaa 

Alajärvi

Alavieska

etc.

But Ä is the second last alphabet in Finnish language, not a version of A, so of course the order should be

Akaa 

Alajärvi

Alavieska

.

.

.

Ähtäri

Äänekoski

My regional settings are defined as "Finnish" in Locale for import and Model language. This has worked fine before, so I'm pretty baffeld about where this is coming from. 

[v-cherch-msft]

Hi @Anonymous

You may try to add a column as sort order for them. Then you may try to use Sort by column. If you need further help, please share some data sample and expected output. You can upload it to OneDrive or Dropbox and post the link here.

Regards,

Cherie

[Anonymous]

Thanks for your reply. We should not have to build a workaround, PowerBI should work correctly with international settings despite display language, like the rest of Office. Very strange that a localized version work correctly (I haven't tested how non-Swedish sorting works in the localized version). Since PowerBI is a design tool, I bet most users will use the English version.