Table of Contents
In Power BI, there are a few ways to round numbers to 2 decimal places. One method is by using the ROUND function, which takes two arguments: the number to be rounded and the number of decimal places. For example, if we have a column with values 12.3456 and 9.8765, we can use the formula ROUND([Column], 2) to round these numbers to 12.35 and 9.88, respectively. Another way is by using the FORMAT function, which allows for more customization in terms of formatting. For instance, we can use the formula FORMAT([Column], “0.00”) to round the same numbers to 12.35 and 9.88. Both of these methods can help ensure that our data is displayed with the desired level of precision.
You can use one of the following methods to round values to 2 decimal places in Power BI:
Method 1: Use the decimal places feature in Column tools
Method 2: Use the ROUND function in DAX
The following examples show how to use each method in practice with the following table in Power BI:
Example 1: Round to 2 Decimal Places Using Column Tools
One way to round values in a column to 2 decimal places is to click the column name, then click the Column tools tab along the top, then type the value 2 into the decimal places box:
Notice that each value in the Avg Sales column is now rounded to 2 decimal places.
For example:
- 11.89343 has been rounded to 11.89.
- 12.2342 has been rounded to 12.23.
- 20.2009 has been rounded to 20.20.
And so on.
Example 2: Round to 2 Decimal Places Using DAX
Another way to round the values in a column to 2 decimal places is by using the ROUND function in DAX.
To do so, click the Table tools tab along the top and then click New column:
Then type the following formula into the formula bar:
Avg Sales Rounded = ROUND('my_data'[Avg Sales], 2)
This will create a new column named Avg Sales Rounded that rounds each value from the Avg Sales column to 2 decimal places:
Note #1: If any of the rounded values end in zero, the zeros will not be shown. For example, the value 15.0012 is rounded to 15.00, which is shown as just 15.
Note #2: You can find the complete documentation for the ROUND function in DAX .
Additional Resources
The following tutorials explain how to perform other common tasks in Power BI: