Forum Discussion
Jawed
Helper III
Helper IIIConvert 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...
MarcelBeug
Community Champion
Community ChampionIn 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.
JawedHelper III
Helper IIIThank 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 (-)?
- MarcelBeug
No, the number format (0 or -) in Excel makes no difference for Power Query.