How to add commas to numbers in Power BI
Formatting numbers with commas in Power BI can be achieved by using the FORMAT function or changing the data type of the column.
1. Using the FORMAT function
The FORMAT function in Power BI allows you to specify a format for a given expression. To add commas to numbers using the FORMAT function, follow these steps:
- Select the column or measure you want to format.
- Go to the Modeling tab in the Power BI Ribbon.
- Click on the Format drop-down menu.
- Select the format option that includes commas, such as “General Number” or “Currency”.
- Customize the format by clicking on the ellipsis (…) next to the format drop-down menu. This allows you to specify additional details, such as decimal places or currency symbols.
Here’s an example:
Sales Amount = FORMAT(SalesTable[Amount], "Currency")
2. Changing the data type of the column
Another way to add commas to numbers in Power BI is by changing the data type of the column to a format that includes commas. Here’s how:
- Select the column you want to format.
- Go to the Modeling tab in the Power BI Ribbon.
- Click on the Data Type drop-down menu.
- Select the desired data type that includes commas, such as “Currency” or “Fixed Decimal Number”.
Power BI will automatically format the numbers with commas based on the selected data type.
Note that changing the data type of a column may affect calculations or aggregations performed on that column, so make sure to consider the implications before making changes.
Example:
Sales Amount = SalesTable[Amount]