cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
JERamberg Frequent Visitor
Frequent Visitor

sort order of umlauted characters

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,

 

 

2 REPLIES 2
Microsoft v-cherch-msft
Microsoft

Re: sort order of umlauted characters

Hi @JERamberg

 

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

Community Support Team _ Cherie Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
JERamberg Frequent Visitor
Frequent Visitor

Re: sort order of umlauted characters

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.

Helpful resources

Announcements
New Ranks and Rank Icons in 2020

New Ranks and Rank Icons in 2020

Read the announcement for more information!

New Kudos Given Badges Coming

New Kudos Given Badges Coming

We're rolling out new Kudos Given badges. Find out how many Kudos you've given.

November 2019 Community Highlights

November 2019 Community Highlights

Get an overview of the events and great community content from November.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Solution Authors
Top Kudoed Authors (Last 30 Days)