Forum Discussion
Convert text to number
Hi everyone, I am new to Power BI and this is my first attempt at uploading my budget and actual numbers. Because my budget is columnar, I needed to use the "Unpivot Column" option to sort out th...
In general, when you have values in a column that do not comform to the column type, the values will be visible in the Query Editor, but not after loading the data.
Another possibility would be that you need to transform the data type using Locale, e.g. if the text values have decimal points, but your culture has decimal commas.
Thank you. I will have to run some forensic tests to clear out the data. Probably worth to round the numbers in excel to ensure there is nothing hidden. Does it make any difference if the zero appears as (0) or (-)?
No, the number format (0 or -) in Excel makes no difference for Power Query.