Forum Discussion
dax format () not working
I would like to format the number with thousand seperator and currency symbol. Below is the measure I created. For some reason, the thousound seperator is not working. So instead of showing $1,700, t...
Jeanxyz I think you have in the language definition of the PBIX a region that has . instead of , for numbers. Check your region settings and change it to something like US or UK
I have checked that, it use "," as a seperator, I also checked number format setup in my PC, it also uses "," as a seperator.
If I open a new Power BI file, the measure works well. I think there might be a bug in PB itself, it records the region or windows setup when a file is created (in my case, the pbix file is created by someone else) and it doesn't get updated when users change the setup later.
