Forum Discussion
change format by using dot instead of comma
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
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
2 Replies
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,
LydiaHello,
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
