Forum Discussion
Thousand Separator and Decimal Separator
Microsoft Employeekonstantinos 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?
Memorable Memberpqian 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.
- pqian
konstantinos Thank you for the investigation. I think I've found the cause. I'll contact the service team to get this addressed ASAP.
- konstantinosThanks pqian , glad that helped to spot the issue...
Waiting your update.
- konstantinos
I was informed by MS support ( Brad ) that a fix was pushed to production.
I can confirm that for Dutch/Greek ( probably all ) language the decimal is showing/ reading settings correct on Edge & IE.( not in Chrome )
Unfortunately for me when the display language is English, tried almost all combinations of English & Region, I couldn't find a setting that display English and the correct decimal mark ( comma ) and respects the number format settings.
I would greately appreciate if you or anyone on the community has it working and share the settings.
Thanks for the quick fix, my users are really happy again
- pqian
konstantinos Have you tried Chrome's language settings? You'll have to make sure Dutch is the first one of the group. Restart and try again.
- konstantinos
pqian I tried language settings in Chrome didn't work..probably needs to change account setting language ( I will try it )..But my issue is that I need English language to be first / display in all browsers..since this is what I use to work & demo.
Any suggestions for English and decimal comma?