Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Valuta decimal separator changing from comma to point

Hi, I want to change the local decimal separator voor Valuta in our dutch version being changed from comma to a point.   I tried to do it by change the reginonal settings to English (VS) and to ma...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    Jimmy801 

    It finally worked.

    I'd used the following formula:

    EnglishFormat = SUBSTITUTE(FORMAT('Table'[Collumn],  "#####0.00") ,",",".")

     

    This makes the dutch format to English now. so the separator is changed from comma to point .

    Thanx for you help 🙂

     

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Jimmy801 

It seems this makes a comma "," instead of a point "." thats excatly the opposite i'm trying to achieve

 

What do i have to change in the query to make 

Jimmy801's avatar
Jimmy801
Icon for Community Champion rankCommunity Champion
6 years ago

Hello Anonymous 

 

my solution forces Power BI to format a number written in a different culture into a number in terms of power bi. So the change you want is not a formatting of number from text, applying a culture, but only that a real number in Power BI is shown with .00 instead of ,00. 

Power BI takes your local settings to show a number. So this hasn't to do anything with Power BI but with you Windows installation. To change this goto control panel -> region --> advanced setting and change the format there. Here a screenshot from my local german installation 


If this post helps or solves your problem, please mark it as solution (to help other users find useful content and to acknowledge the work of users that helped you)
Kudoes are nice too

Have fun

Jimmy