Forum Discussion

ThorenSvea's avatar
ThorenSvea
New Member
9 years ago

Sort problems text values, swedish characters

Hi!

 

Having a problem sorting text values in a matrix visual.

I'm listing cities and sales and whish to sort the list by city.

The column is sorted but swedish characters (åäö) are not sorted in alphabetical swedish correct order.

 

I have Swedish as regional setting under Options > Currect File > Locale, doesn't help.

 

Anyone have a solution?

 

Thank you!

Thomas

4 Replies

    • v-haibl-msft's avatar
      v-haibl-msft
      Microsoft Employee
      9 years ago

      ThorenSvea

       

      I’ve got response from PBI team for it. To build the model with correct culture/language model settings, the user should install the appropriate version of the PBI-Desktop. So you need to install the Swedish(sv-SE) version of the PBI Desktop here. Please also note that the model/pbix file would likely need to be recreated as well.

      https://www.microsoft.com/sv-SE/download/details.aspx?id=45331

       

       

       

      Best Regards,

      Herbert

  • JargerBiirli's avatar
    JargerBiirli
    Frequent Visitor
    4 years ago

    Now, five years down the line, I’m running into the same issue. Is it still not possible to make Power BI respect locale settings in alphabetical ordering? Recreating the report is not an option for me.