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

**Additional Resources**

The following tutorials explain how to perform other common tasks in Power BI:

How to Count Number of Occurrences in Power BI

How to Write an IF Statement in Power BI

How to Write an IF Statement with Multiple Conditions in Power BI