How To Add Comma In Thousands Separator In Power Bi

When working with Power BI, you can add a comma as a thousands separator by using the “Format” feature. This allows you to control the display format of your data, including numeric values.

Here’s how you can do it:

1. Select the field or measure you want to format with a thousands separator in the Power BI field pane.
2. Under the “Modeling” tab in the Power BI ribbon, click on the “Format” drop-down menu.
3. From the available options, choose “Decimal places” and set it to zero (0) if you want whole numbers display.
4. Next, select “Use 1000 separator” from the “Format” dropdown menu. This will automatically add commas to represent thousands.
5. You can also modify the decimal symbol, if needed, by selecting “Decimal separator” from the same dropdown menu.

Here’s an example to illustrate this:

By following these steps and using the “Format” feature in Power BI, you can easily add a comma as a thousands separator to your numeric values.