Forum Discussion
Valuta decimal separator changing from comma to point
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 🙂
Community ChampionHello 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
That youre right,
Only the thing in our company is that is isn't allowed to change these settings.
That the reason why i'm trying to solve this in PowerBI.