Explore Courses Blog Tutorials Interview Questions
0 votes
in BI by (17.6k points)

I would like to know how to change the standard format for numbers in Power BI.

The software I use separates decimals by coma "000.000,00", but the idea is to set that to US format: "000,000.00".

How can I fix that?

1 Answer

0 votes
by (47.2k points)
  • Two approaches are available for this problem.

  • In current PowerBi file, if all the data sources are in the European format, you can set the locale of the file accordingly:

  • File -> Options and settings -> Options 





    • Then, Power BI can identify the format for numbers correctly when you change the data type in Query Editor. 

    • If you're just catering for a particular data source, you can use the transformation Replace Values to swap with and then change the data type to decimal number afterward.

Browse Categories