Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

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

  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    Icon for Community Support rankCommunity 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 

    • v-qiuyu-msft's avatar
      v-qiuyu-msft
      Icon for Community Support rankCommunity Support

      Hi Anonymous,

       

      The issue will be fixed in May or Jun release. 

       

      Best Regards,
      Qiuyun Yu 

      • v-qiuyu-msft's avatar
        v-qiuyu-msft
        Icon for Community Support rankCommunity Support

        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