Forum Discussion

Natxo's avatar
Natxo
New Member
10 years ago
Solved

Thousand Separator and Decimal Separator

Hi!!! I'm writing from Spain. I'm having problems with decimal separator and thousand separator. Here in Spain, decimal separator is a comma and thousand separator is a point. But PowerBi goes wrong,...
Need Help
  • pqian's avatar
    pqian
    10 years ago

    Natxo The screenshot looks correct to me, the thousands separator is "." and decimal is ","

     

    What are you expecting?

pqian's avatar
pqian
Icon for Microsoft Employee rankMicrosoft Employee
10 years ago

konstantinos, Natxo Today we released a QFE on the Jan update that should address this issue. Can you download the latest bits and try again?

  • Natxo's avatar
    Natxo
    New Member
    10 years ago

    pqiankonstantinos Hi! Is this th last version? 

    I have the same problem after install that version. Are there newer? Thanks!!!!

     

    • pqian's avatar
      pqian
      Icon for Microsoft Employee rankMicrosoft Employee
      10 years ago

      Natxo The screenshot looks correct to me, the thousands separator is "." and decimal is ","

       

      What are you expecting?

      • Natxo's avatar
        Natxo
        New Member
        10 years ago

        pqian Yes...I need to go to an optician...Sorry. It's correct. Perfect! Thank you very much!!!!

  • Natxo's avatar
    Natxo
    New Member
    10 years ago

    pqian Thanks a lot! I am downloading the last version. In a few minutos I can give you a feedback about it. GO! GO! GO! :)

  • konstantinos's avatar
    konstantinos
    Icon for Memorable Member rankMemorable Member
    10 years ago

    pqian Great is working..Thanks for the fast patch.. The advanced download link page still hasn't the latest one. 

    Question: regarding the service are we expecting an update also? or we need to do some action ? Upload or refresh the pbix reports don't work..

     

    • pqian's avatar
      pqian
      Icon for Microsoft Employee rankMicrosoft Employee
      10 years ago

       konstantinos Are you using Chrome to browse the service? Does the problem also repro in IE as well?

       

      The service picks up the browser language and regional settings. In IE it's the system one, in Chrome they have a separate settings for it, you may have it set to English?

      • konstantinos's avatar
        konstantinos
        Icon for Memorable Member rankMemorable Member
        10 years ago

        pqian  The issue in Service still exists. 

         

        I live in Netherlands but unfortunately I don't speak Dutch , even if I did for display language  I always use English language.

         

        So the windows dispaly language is and was in English (US).

         

        The service before January was showing correct the delimiters for Europe/Netherlands, I didn't change any settings ( only after the problem to trying to fix the delimiter display and then set it back to the settings I had before)

         

        Let's start:

        My workstation laptop / OS version :  Windows 10 Home -  1511 build 10586.104 

         

         

         

         

         

         

         

         

         

         

         

         

         

        I use Chrome mostly but the issue appears in all browsers.  screenshot below , The language is English Canada due to playing aroung with all Engish Language packs. The same occurs with English US and English United Kingdom.

        As you notice PowerBI desktop is fixed ( yeahh) due to latest version download.

         

         

         

        You might suppose that  English language is the problem.. Wrong..I change settings to Greek display language ( I am Greek and the delimiters are same as Netherlands and most of Europe ).

         

         

         

         

        As you might notice chrome has his own settings. Let's try to change it also in Greek.... Interesting , chrome display menu etc in Greek but PowerBI service uses the Settings from Display language. ( Was set back to English US) ..

         

         

        Before you say that I mixed up settings or a problem with my laptop...I used the laptop of a Dutch user.

         

        User laptop = Windows 10 home 

         

         

         

         

        Now open PowerBI service in Internet Explorer and Chrome.. Regional settings in Netherlands and Display language Dutch. Not even installed another language pack. 

        The same delimiter error..

         

         

         

        Unless I missing something ( might be the case )   it seems to me that there is an problem how PowerBI service reads internet explorer display language or an win 10 update mixed things up..

         

        Hope the above helps..

         

        P.S. If is in your knowledge please advice which English language should be use. But of course many users are affected that using English US instead of Dutch and is not possible for everyone to swith languages specially because was working previous months.