Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

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 prop...
Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    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

carinatina_pbi's avatar
carinatina_pbi
Frequent Visitor
5 years ago

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