Power BI - Numeric Format

Question

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?

Answer 1

• 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.