One POwer BI files with commas and other file no commas, want to have comma as well

[joseph248]

Hi Everyone,

I have 2 Power BI files, both pulling from the same excel sheet and both using the Matrix visual.

One of it have comms, example 1,000 and my other Matrix dont have comms 1000.

I want to set it as well with comma, but can't found out where

I want make 1155M to 1,155M

I try using format, but not working.

My other file do have the commas, can't seem to found the different?

Can someone help... me... 

Thank you for your time in this matter.

[amitchandak · Accepted solution]

@joseph248 , is it number format. if yes, two place

1. https://docs.microsoft.com/en-us/power-bi/desktop-custom-format-strings

2. COlumn/measure tools - You will get once click on column or measure

[joseph248]

Thank you everyone for the help.

[Greg_Deckler]

@joseph248 - Click on the column or measure in the Fields area. Then look under Column tools or Measure tools in the ribbon and there you will see a , (comma) button. Click it.

[joseph248]

Thank you for the quick reply, 

I dont have that on my ribbon