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

Power BI does not assume regional settings for thousands separator

Hello everyone,

 

My power BI desktop app is not recognizing the regional settings of my PC.

Despite having the regional settings set to the US everywhere, in both Windows settings and Power BI settings, Power BI still shows values using comma as the thousands separator and dot as the decimal separator:

1.png

2.png

 

3.png

4.png

 

In Power BI whole numbers still show up like this:

5.png

 

Besides this, I have also tried changing the thousands separator using the "Change Type with Locale" option, but the values still remain the same:

6.png

7.png

Can someone please help regarding this issue?

 

Thank you very much!

 

6 REPLIES 6
Highlighted
Super User IV
Super User IV

Re: Power BI does not assume regional settings for thousands separator

Hi @dat_da_1991 

 

Please refer to this post.

https://community.powerbi.com/t5/Desktop/Re-Thousand-Separator-for-Measures/m-p/575714

 

 

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
LinkedIn

 

 

Highlighted
New Member

Re: Power BI does not assume regional settings for thousands separator

Hi @Mariusz,

 

Thank you for your response.

 

I am already using the normal "Card" visualization option, not the "Advanced Card" option. In fact, I don't even have available the "Advanced Card" option in the Visualizations tab.

 

I am unfortunately still having the issue of commas instead of dots.

 

Again, thank you for your help.

 

Best regards.

 

Highlighted
Community Support
Community Support

Re: Power BI does not assume regional settings for thousands separator

Hi @dat_da_1991 ,

 

Based on my test, it seems the display  of number in visual does not follow the customize format setting, after we set the regoin to Chile(it use dot as thousands spereator defaultly), it show as expected.

 

6.jpg

 

But if we use format function, it will use the customize format setting.

 

Format = FORMAT(SUM('Table'[Amount]);"Standard")

 

4.jpg

 


Best regards,

 

 

 

Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
New Member

Re: Power BI does not assume regional settings for thousands separator

Hi @v-lid-msft,

 

Thank you for your response.

 

Indeed, the display in Power BI does not seem to assume the format setting in the region settings, as I have set the format to Portuguese (Portugal) where the thousands separator is "space", but Power BI still shows the thousands separator as "comma".

 

Regarding the Format formula, that option is not very suitable for my particular case, as I would need to edit a LOT of formulas.

I am looking for a way to change the thousands separator in a more "bulk" way.

 

Again, thank you for trying to help.

 

Best regards.

 

Highlighted
Community Support
Community Support

Re: Power BI does not assume regional settings for thousands separator

Hi @dat_da_1991 ,

 

Thank you to point it, We have the same result as yours in both desktop and service, we will try to report and confirm with others, then we will update here if we get anything new.


Best regards,

 

 

Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
Super User IV
Super User IV

Re: Power BI does not assume regional settings for thousands separator

Hi @dat_da_1991 

 

This looks like a bug to me, if you are not running the most up to date version then please upgrade and try again else you can report it as am Issue here.
https://community.powerbi.com/t5/Issues/idb-p/Issues

 

 

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
LinkedIn

 

Helpful resources

Announcements
August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Upcoming Events

Upcoming Events

Wondering what events you could join or have an event to promote yourself? Check out our Upcoming Events.

Community Summit Australia – Join Online!

Community Summit Australia – Join Online!

Be a part of the leading Microsoft Business Applications digital event, curated for the APAC community.

Top Solution Authors
Top Kudoed Authors