Power BI - Numeric Format

number-formatting powerbi powerbi-embedded powerbi-datasource
Petter_M picture Petter_M · Jan 3, 2017 · Viewed 16.8k times · Source

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

Foxan Ng picture Foxan Ng · Jan 13, 2017

There are two approaches to this problem.

If all the data sources you have in the current Power BI file are in the European format, you can set the locale of the file accordingly:

File -> Options and settings -> Options locale

Once set, Power BI can identify the format for numbers correctly when you change the data type in Query Editor. source changed type

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

replace values

Related questions

Show a number to two decimal places

What's the correct way to round a PHP string to two decimal places? $number = "520"; // It's a string from a database $formatted_number = round_to_2dp($number); echo $formatted_number; The output should be 520.00; How should the round_to_2dp() function …

Read More
Format number to always show 2 decimal places

I would like to format my numbers to always display 2 decimal places, rounding where applicable. Examples: number display ------ ------- 1 1.00 1.341 1.34 1.345 1.35 I have been using this: parseFloat(num).toFixed(2); But it's displaying 1 as 1, rather than 1.00.

Read More
How to convert decimal to hexadecimal in JavaScript

How do you convert decimal values to their hexadecimal equivalent in JavaScript?

Read More