Forum Discussion

Jawed's avatar
Jawed
Icon for Helper III rankHelper III
8 years ago

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...
Need Help
Jawed's avatar
Jawed
Icon for Helper III rankHelper III
8 years ago

Hi MarcelBeug. I tried that option as well. Somehow it is not picking it. Is having zeros in the cells going to make the difference? When I am on the Query Editor, I can see the numbers but, when I "Close & Apply" and come out of it, the numbers simply disappear. I may be doing something wrong but dont seem to think of anything at this moment.

MarcelBeug's avatar
MarcelBeug
Icon for Community Champion rankCommunity Champion
8 years ago

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.

  • Jawed's avatar
    Jawed
    Icon for Helper III rankHelper III
    8 years ago

    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 (-)?

    • MarcelBeug's avatar
      MarcelBeug
      Icon for Community Champion rankCommunity Champion
      8 years ago

      No, the number format (0 or -) in Excel makes no difference for Power Query.