cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Memorable Member
Memorable Member

Re: Thousand Separator and Decimal Separator

@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 

 

4.png

 

 

 

 

 

 

 

 

 

 

 

 

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.

 

1.png

 

 

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 ).

 

 

 

2.png

 

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 

 

5 (1).png

 

 

 

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..

 

6 (1).png

 

 

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.

 

 

 

 

Konstantinos Ioannou
Highlighted
Microsoft
Microsoft

Re: Thousand Separator and Decimal Separator

@konstantinos Thank you for the investigation. I think I've found the cause. I'll contact the service team to get this addressed ASAP.

Highlighted
Memorable Member
Memorable Member

Re: Thousand Separator and Decimal Separator

Thanks @pqian , glad that helped to spot the issue...
Waiting your update.
Konstantinos Ioannou
Highlighted
Memorable Member
Memorable Member

Re: Thousand Separator and Decimal Separator

@pqian  

 

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

Konstantinos Ioannou
Highlighted
Microsoft
Microsoft

Re: Thousand Separator and Decimal Separator

@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.

Highlighted
Memorable Member
Memorable Member

Re: Thousand Separator and Decimal Separator

@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?

Konstantinos Ioannou
Highlighted
Microsoft
Microsoft

Re: Thousand Separator and Decimal Separator

@konstantinos try adding a language=xx at the end of the query string. For example:

dashboards/5ed091ea-59bb-4b3b-a69d-a3f3fa5beea9?language=it

 

This setting depends on the deployment and may or may not be available on your cluster. It also changes the locallization settings. Unfortunately I don't think Globalization can be configed differently from your locale. So I don't think there's an English setting that uses , decimals (to be honest...to an English speaker, this could be very confusing. So if you are presenting to English audience, sticking to . is probably the better choice)

Highlighted
Memorable Member
Memorable Member

Re: Thousand Separator and Decimal Separator

Thanks @pqian..I will try it.

 

Unfortunately my English audience is Dutch, Greeks , Danish, etc that we all use comma as decimal but English to communicate.

 

Before January I was able to use English & comma as decimal (always used English as Display language )  that is why I also saw the change to dot and post the issue.

 

So probably I will give up my hopes to use it again!!

 

Thanks for all the work and info

Konstantinos Ioannou
Highlighted
Microsoft
Microsoft

Re: Thousand Separator and Decimal Separator

@konstantinos You made a good point, I think Globalization settings and Localization settings should indeed be separated. Don't give up hope yet, I'll contact the team behind this.

Highlighted
Memorable Member
Memorable Member

Re: Thousand Separator and Decimal Separator

@pqian Truth is I never give up hope with PowerBI Team!!Smiley Happy Thanks

Konstantinos Ioannou

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Upcoming Events

Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Top Solution Authors
Top Kudoed Authors