cancel
Showing results for 
Search instead for 
Did you mean: 
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
Winner of T-Shirt Design

Power BI T-Shirt Design Challenge 2023

Find out who won the T-Shirt Design Challenge and the top 3 finalists.

March 2023 Update3

Power BI March 2023 Update

Find out more about the March 2023 update.