Forum Discussion

Jawed's avatar
Jawed
Helper 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
Zubair_Muhammad's avatar
Zubair_Muhammad
Community Champion
8 years ago
Hi @ Jawed, This error might be because you chose to keep errors. Try removing errors and then change type of Budget Amount to Decimals
  • Jawed's avatar
    Jawed
    Helper III
    8 years ago

    Thank you Zubair_Muhammad. I deleted them and then tried it again with no luck. 

    • MarcelBeug's avatar
      MarcelBeug
      Community Champion
      8 years ago

      According to the data type symbol (123) in the column header, you changed the type to Whole Number instead of Fixed Decimal.

       

      Personally I'm not in favour of data type Fixed Decimal (which is the same as currency), because it has 4 decimals.

       

      I would prefer Decimal Number instead, and make sure that any currency amounts are properly rounded.

       

      • Jawed's avatar
        Jawed
        Helper 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.