cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
AlexeyZ Visitor
Visitor

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
Moderator v-qiuyu-msft
Moderator

Re: Decimal and Thousand Separators

Hi @AlexeyZ,

 

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.
Moderator v-qiuyu-msft
Moderator

Re: Decimal and Thousand Separators

Hi @AlexeyZ,

 

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.
Moderator v-qiuyu-msft
Moderator

Re: Decimal and Thousand Separators

Hi @AlexeyZ,

 

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.
dquinter Visitor
Visitor

Re: Decimal and Thousand Separators

Please correct this issue in Power BI Desktop RS Man Indifferent