Change comma separation format in numeric field from India to US

[Kunal_Epigeeus]

Hi Community members,

I am using numeric fields in table chart to create reports. I have added comma's seperation in that field.
But, comma seperation in coming in India format. I need it in US format as mentioned below:

Current Number format: 1,11,111
Required Number format: 111,111

[v-kongfanf-msft · Accepted solution]

Hi @Kunal_Epigeeus ,

You can set the formatting regionally in power query.

Best Regards,
Adamk Kong

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Kunal_Epigeeus]

Hi @lbendlin @Ritaf1983 @Ashish_Mathur @Idrissshatila @Greg_Deckler 
Guys have you face this issue before. Could you please help me ?

Regards,
Kunal

[Kunal_Epigeeus]

hi @qqqqqwwwweeerrr 
Thanks for your response and sharing the details

I tried both the approach shared by you. But, still I am facing this issue 
I think there is some other issue. Do you have any other solution for this issue 

Regards,
Kunal

[qqqqqwwwweeerrr]

Hi @Kunal_Epigeeus 

can you share schreenshot of your current version of your field along how you it looks on dashboard that will help to understand the problem, as you have said you have used table it donot have format option

Regards

[qqqqqwwwweeerrr]

Hi @Kunal_Epigeeus 

You can try this: 

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

I understand you might not in favour of creating new column but if you got stuck this can be used another way to play around is go to data model, select the columns and check below image 

if you play around this you might get better way of formating. 

Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Check for more intersing solution here: https://www.youtube.com/@letssolveproblem

Regards

[Kunal_Epigeeus]

Hi @amitchandak 

Can this be achieved?