Forum Discussion
Solved
Error when changing text to number
Hi! I am really new to PowerBI and im just trying to learn the basics for now. But I got stuck almost instantly... Im using this dataset from Kaggle with orderdata. What I want to do is begin t...
replace .0 with blank for all columns then try to convert into nbumbers .
you need to select a column then you can find replace under the transform section.
this should work .
If my answer helped sort things out for you, i would appreciate a thumbs up 👍 and mark it as the solution ✅
It makes a difference and might help someone else too. Thanks for spreading the good vibes! 🤠
So I might have solved this actually. My theory is that im using PowerBI installed with swedish settings where a decimal is (,) and the dataset is formatted with american settings using (.) as a decimal.
I tried to transform a column by "using locale" and setting the settings so american (US).
And now I can use numerical values!