How to add comma thousand separator in Power BI [Query Editor]

Question

There is a column with numbers like :

ex.
12876391

Desired to convert like

12,876,391

in whole column.

I cannot find the simple solution in many forum . How can i achieve it ?

Answer 1

You can first select the column in the Fields pane, and then find the Thousands separator options under Modeling -> Formatting.

Answer 2

I had a table of Google Analytics data, no Modelling > Format option was showing. I went to the regular Format (paint roller) again no option except for Values > Decimal Places, which was on Auto and grayed out.

Then I discovered if you click on the actual metric you want to format in the data Fields area, lo and behold, you get two new tabs up top: Table Tools and Column Tools. Column Tools has the usual Excel-type formatting options.