Forum Discussion
System decimal separator not recognized
Hi,
Shortly said: All numbers are displayed with coma as decimal separator instead of a dot, while my system decimal separator is already set at dot. Why?!
I have already set my measures and value fields to decimal format, and clicked on this button "Display the values in this column with commas as a thousands separator" for every single measures / data field.
In File > Option > Regional Settings, I tried different "Locale for import" (USA, Germany, English (Swaziland), ...). Doesn't change a thing.
I also tried changing the format directly in the query using the local parameter. No change either.
Is there anything I'm missing here?
Here are my regional settings, FYI:
Thanks.
4 Replies
- Pragati11Super User
Hi Anonymous ,
Can you share screesnhot around what you are seeing in Power BI?
Also, in Power BI's settings, try to use the following settings:
Thanks,
Pragati
- AnonymousNot applicable
I just tried those settings but still a comma is appearing- AnonymousNot applicable