In Power BI, you can add a thousand separator to format your numbers using the Format function. Here is an example of how to do it:
Step 1: Open the Power Query Editor
The Power Query Editor is where you can modify your data before loading it into Power BI. To open it, select “Edit Queries” from the “Home” tab in the Power BI Desktop.
Step 2: Format the Number Column
Once you are in the Power Query Editor, find the column that you want to add the thousand separator to. Right-click on the column header and select “Change Type” > “Using Locale”.
Step 3: Apply the Number Format
In the “Using Locale” dialog box, select the appropriate locale for your data. For example, if you are working with US data, select “English (United States)”. Then, click on the “Options” button.
Step 4: Configure the Number Format Options
In the “Number Format Options” dialog box, select the “Custom” category. In the “Format Code” field, enter the appropriate format code to add the thousand separator. For example, if you want to use a comma as the thousand separator, enter “#,##0” as the format code. You can also add decimal places if needed, such as “#,##0.00” for two decimal places. Click “OK” to save the changes.
Step 5: Close and Apply the Changes
Once you have configured the number format options, click “OK” to close the “Using Locale” dialog box. Then, click “Close & Apply” to apply the changes and load the data into Power BI.
Now, your numbers in the selected column will be displayed with the thousand separator according to the format code you specified. For example, if you had a number “1000000” in the column, it will be displayed as “1,000,000”.