change format by using dot instead of comma

[Anonymous]

hi all,

want to change the format of my data, the data looks like this: 62,224 (with comma) and i want to switch to 62.224 (with dot).

tried to solve it by replace value but this is not the proper solution....

any ideas

thnx

M

[carinatina_pbi]

Hello,
I am facing the same issue.

Windows Regional settings are Switzerland and correct displayed with apostrophe.

Windows Regional Settings

Into PBI also Regional setting set to Switzerland.

PBI Regional Settings

Into the table I can see it correctly with apostrophe but into the report this is with comma.

Into TableReport

Please see attached all steps above.

How to solve it?

Thanks and kind regards,

Carina

[Anonymous · Accepted solution]

@Anonymous,

When changing thousand seperator , you would need to firstly change region setting in your computer, for more details, please review my reply in this similar thread.

In addition, please note that the thousand seperator doesn't work as expected in February update and March update of Power BI Desktop after changing region setting, and this is a know issue which will be fixed in May or June update of Power BI Desktop. Currently, you can use previous version of Power BI Desktop such as January update to work aournd this issue.

Regards,
Lydia