Error with thousands separator

[OriExil]

Good, A while ago I've been dragging this problem, but I can't find a solution in any language.
When I add thousands separators to a numeric value it only gives me the first separator from right to left, an example would be something like this:
5,000,000 (As it should be)
5000,000 (As seen)
It only happens with values with 6 or more "zeros" for obvious reasons.
I've already tried to change the regional format and so on, but I can't fix it, it's quite annoying.
Thank you very much in advance!

[v-xuding-msft · Accepted solution]

Hi @OriExil ,

You can try to use custom format strings in Power BI Desktop. More Info: https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-custom-format-strings

I create a column typed as whole number. Like below:

Click the Model View, choose the column and then we select Custom in Format. Steps are shown as below:

We will have three options to choose:

Choose the third one and then delete $:

Result:

If this can't work, you could create a calculated column with FORMAT function:

Column = FORMAT('Table'[Column1],"#,###,###")

Note: FORMAT function returns text values. 

[OriExil]

Funciono perfectamente, muchisimas gracias!

[parry2k]

@OriExil not sure what is going on, I tried at my end and it works. What is digital grouping setting in your region settings:

[OriExil]

@parry2k I have it configured the same way, only I use the dots as thousands separators.

Only on my desktop computer does this happen, on my notebook I have no problems.

Thank you for your time!

[parry2k]

@OriExil this is weird,  are you using the same version of powerbi on both the computers. I guess you have regional setting in power bi set to default windows settings, correct?