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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

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
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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