Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Fabric community is now in read-only for platform upgrade. Learn more

Reply
floralsnow
Frequent Visitor

Incorrect decimal symbol

I have a problem where I have set the region to English (Sweden) in Powerbi and English (Sweden) in Window's region settings.

In Sweden, the decimal symbol i "," and not ".".

I've confirmed that this symbol is the chosen one in Window's region settings and in the power query editor, the decimal symbol shows correctly, as show in this picture.

floralsnow_0-1647627656116.png

 

But in the visual, it shows the decimal as "." and not ",".

 

floralsnow_1-1647627676690.png

 

I don't want to go against my operating system settings like some of the posts I found on the topic, I'd just like the visual to obey my operating system settings.

 

Is there someone who know what I'm missing?

2 REPLIES 2
floralsnow
Frequent Visitor

The locale is correct in power BI.

floralsnow_0-1648140543303.png

 

 

and the decimal is displayed properly in the query

floralsnow_1-1648140603426.png

 

 

Just not in the visual

floralsnow_2-1648140631865.png

 

 

This inconsistency is what confuses me. All settings I've set should ensure that the swedish regional formatting is used, i.e. a comma for the decimal.

ronrsnfld
Super User
Super User

I think there is an option for that.  In Power BI Desktop:   File > Options and settings > Options > Global (and/or File) > Regional Settings may not be set properly

Helpful resources

Announcements
FabCon and SQLCon Barcelona 2026

FabCon & SQLCon – Barcelona 2026

Join us in Barcelona for FabCon and SQLCon, the Fabric, Power BI, SQL, and AI community event. Save €200 with code FABCMTY200.

Power BI DataViz World Championships carousel

Power BI DataViz World Championships - June 2026

A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.