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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
Anonymous
Not applicable

Decimal and Thousand Separators

Hi,

 

I know, that this issue discused many times / go through forum. Seems to me, it the issue still exist or I missed smth.

 

Current setup:

  • Windows 10 64-bit. Office 2016 (365) and Power BI 
  • Power BI Version: 2.55.5010.641 64-bit (February 2018)
  • Windows Control Panel Setting: "Decimal symbol" = ',' "Digital grouping symbol" = ' '. So, Windows format: 123 456 789,00
  • Power BI settings: File -> Options and Settings -> Options -> Current file -> Regional Settings -> "English (Europe)"

 

  • Setting works fine for Excel PowerPivot. Both "Currence" and "Number" are in line with Windows Regional settings

 

Issue with Power BI

  • Query windows of Power BI : Decimal symbol ="," Digital grouping symbol ="" (blank) E.g.: 123456789,00
  • Data / Report windows of Power BI: Decimal symbol = '.' "Digital grouping symbol" = ',' E.g.: 123,456,789.00

Can't find the way to adjust it to desired format, as in Windows Regional, E.g.: 123 456 789,00

 

 

Please, help.

 

Kind regards,

Alexey

4 REPLIES 4
v-qiuyu-msft
Community Support
Community Support

Hi @Anonymous,

 

I can reproduce the issue in the latest Power BI desktop version 2.55.5010.641 64-bit (February 2018) on my side. I already reported it internally, will update here once I get any information. 

 

Best Regards,
Qiuyun Yu 

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi @Anonymous,

 

The issue will be fixed in May or Jun release. 

 

Best Regards,
Qiuyun Yu 

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi @Anonymous,

 

There is a desktop May version released, please update your desktop to this version then test if the issue is gone. 

 

Best Regards,
Qiuyun Yu 

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Please correct this issue in Power BI Desktop RS Man Indifferent

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.