0 votes
1 view
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.

Welcome to Intellipaat Community. Get your technical queries answered by top developers !