cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Natxo Frequent Visitor
Frequent Visitor

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
pqian Senior Member
Senior Member

Re: Thousand Separator and Decimal Separator

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

 

What are you expecting?

20 REPLIES 20
konstantinos Senior Member
Senior 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
pqian Senior Member
Senior Member

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?

Natxo Frequent Visitor
Frequent Visitor

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

Natxo Frequent Visitor
Frequent Visitor

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! Smiley Happy

Natxo Frequent Visitor
Frequent Visitor

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

pqian Senior Member
Senior Member

Re: Thousand Separator and Decimal Separator

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

 

What are you expecting?

Natxo Frequent Visitor
Frequent Visitor

Re: Thousand Separator and Decimal Separator

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

konstantinos Senior Member
Senior 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
pqian Senior Member
Senior Member

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
GregDeckler

How to Get Your Question Answered Quickly

Power BI Super User, Greg Deckler, explains

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Back to School Contest

Back to School Contest

Engage and empower students with Power BI!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Top Ideas
Users Online
Currently online: 41 members 946 guests
Please welcome our newest community members: