Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

System decimal separator not recognized

Hi,

 

Shortly said: All numbers are displayed with coma as decimal separator instead of a dot, while my system decimal separator is already set at dot. Why?!

I have already set my measures and value fields to decimal format, and clicked on this button "Display the values in this column with commas as a thousands separator" for every single measures / data field.

In File > Option > Regional Settings, I tried different "Locale for import" (USA, Germany, English (Swaziland), ...). Doesn't change a thing.

I also tried changing the format directly in the query using the local parameter. No change either.

 

Is there anything I'm missing here?

 

Here are my regional settings, FYI:

 

 

Thanks.

4 Replies

  • Hi Anonymous ,

     

    Can you share screesnhot around what you are seeing in Power BI?

     

    Also, in Power BI's settings, try to use the following settings:

     

    Thanks,

    Pragati

    • Anonymous's avatar
      Anonymous
      Not applicable


      I just tried those settings but still a comma is appearing

       

      • Anonymous's avatar
        Anonymous
        Not applicable