Forum Discussion
Right format for my data settings
Hello,
My original data, which I can download into a csv file, has the thousands separator as a blank space and the decimal as a point.
I have tried everything and nothing works to Power BI correctly show my data.
I have for example a 6.6 number, which should be considered as 6 units and Power Bi is always considering it wrongly. I tried to alter my settings for another country to see it this changed but nothing.
Hi351313002,
There is no special Regional Setting to solve this problem in Power BI Desktop , please try to change using locale and set it to number with locale as English (US) .
Hope it helps.
Best Regards,
Caitlyn Yan
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.
3 Replies
351313002 provide some sample data and expected output, it is not clear what you are trying to do and what is the actual problem? Read this post to get your answer quickly.
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490To put it simply: I need my power bi desktop to have a "Regional Setting" that matchs my original data settings for data format, which are blank space for the thousands delimiter and a point for the decimal delimiter.
Hi351313002,
There is no special Regional Setting to solve this problem in Power BI Desktop , please try to change using locale and set it to number with locale as English (US) .
Hope it helps.
Best Regards,
Caitlyn Yan
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.
