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

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, (decimal separator = point and thousand separator = comma). The regional configurator is correct and Excel configurator is correct too. What Can I do? Can anybody help me? Thank's a lot!

 

Natxo.

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Microsoft
Microsoft

Re: Thousand Separator and Decimal Separator

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

 

What are you expecting?

View solution in original post

21 REPLIES 21
Highlighted
Memorable Member
Memorable Member

Re: Thousand Separator and Decimal Separator

I am facing the same problem. Fortunately is a known issue and they are working on it..check this thread
http://community.powerbi.com/t5/Desktop/Regional-number-format-delimiters-in-Europe-PowerBI-Desktop/...
Konstantinos Ioannou
Highlighted
Microsoft
Microsoft

Re: Thousand Separator and Decimal Separator

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

Highlighted
New Member

Re: Thousand Separator and Decimal Separator

Hi Konstantinos!!! Sorry for that. I did not see your post about this issue. I am downloading the last version and...Let's see. 🙂 

Highlighted
New Member

Re: Thousand Separator and Decimal Separator

@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! 🙂

Highlighted
New Member

Re: Thousand Separator and Decimal Separator

@pqian@konstantinos Hi! Is this th last version? Last-Version.png

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

 

Comma.png

Highlighted
Microsoft
Microsoft

Re: Thousand Separator and Decimal Separator

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

 

What are you expecting?

View solution in original post

Highlighted
New Member

Re: Thousand Separator and Decimal Separator

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

Highlighted
Memorable Member
Memorable Member

Re: Thousand Separator and Decimal Separator

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

 

1.png

Konstantinos Ioannou
Highlighted
Microsoft
Microsoft

Re: Thousand Separator and Decimal Separator

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

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