Add commas to a text numeric value

[Rigoleto]

I having problems to format some values that are being showing in a Matrix, just I did some trick in order to simulate the Totals and Averages, I have changed to values data types from int to text, my goal is show blanks in the matrix instance of zeros, well do I need to do is put commas to the values, just liek the screenshot shonws.

[iris-yip]

Format([Column1], "#,##0")

[ranahamza]

great 👍

[Ataul_Hossain]

Thanks @iris-yip this is the right answer the other examples don't work for 100,000 and above.

[ChrisMendoza]

@Rigoleto,

You could try something like what I've show in https://community.powerbi.com/t5/Desktop/Spacing-between-values/m-p/437119#M201622.

Just change the " " (space) to ","

[v-juanli-msft · Accepted solution]

Hi @Rigoleto

Thanks to ChrisMendoza, i can test with it successfully.

Column =
VAR right =
    RIGHT ( [Column1], 3 )
VAR left =
    SUBSTITUTE ( [Column1], right, "" )
RETURN
    COMBINEVALUES ( ",", left, right )

Best regards

maggie 

[BKirsch12]

Select the data you want to format, then head to modeling, and choose format, or hit the comma in the formatting box.

[Rigoleto]

Hey, 

Remember the value is a Text value, just I did change from numeric to text, now Do I want to do is put some commas