Forum Discussion
wrong data formatting after refreshing dataset/dashboard
Hi. That's strange. I think you could try adjusting the format to the measure manually. Get in the power bi desktop and specify the format of the measure with a custom string that make sense for you. You can check this doc to read how it works:
https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-custom-format-strings
That should make sure you won't have an issue with millions, thousands or hundreds. Consider that decimal points are a different story that depends on the browser language on how it will show it (dots and commas)
I hope that helps,
Hi, ibarrau i've tried but this doesn't work as this issue comes not from the model but just when I ask to refresh the model.
the original file has "," as separator for the decimal and "." as separator for thousands (Italian standard). In my power bi desktop I have done the change to the international standard replacing "." with nothing and "," with "." in order to get clean data. Doing this it works perfectly in desktop but not when I push this to a refresh in the app service on line. Wondering how can I overcome this issue
Thanks
G