Forum Discussion

Nosh10's avatar
Nosh10
Helper II
6 years ago
Solved

Integer not Converting to Decimal

Hello,    I have a file, and one of the columns has decimal points. However, Power BI uploaded the column as a whole number. I changed the column in the data tab to reflect a decimal number, bu...
Need Help
  • Nosh10's avatar
    Nosh10
    6 years ago

    I solved the issue. I needed to update the data in the advanced editor. 

camargos88's avatar
camargos88
Community Champion
6 years ago

Hi Nosh10 ,

 

Can you share the pbix ? If no, take a print of Query Editor, to check the applied steps.

Nosh10's avatar
Nosh10
Helper II
6 years ago

Please see below for view of query editor

  • amitchandak's avatar
    amitchandak
    Super User
    6 years ago

    Nosh10 , Right-Click on the table, you will see Advanced Editor option. You will see a text like this

     

    let
    Source = Excel.Workbook(File.Contents("...bi\decimal.xlsx"), null, true),
    Sheet1_Sheet = Source{[Item="Sheet1",Kind="Sheet"]}[Data],
    #"Promoted Headers" = Table.PromoteHeaders(Sheet1_Sheet, [PromoteAllScalars=true]),
    #"Changed Type" = Table.TransformColumnTypes(#"Promoted Headers",{{"Number", type number}, {"Number1", type number}, {"Name", type text}})
    in
    #"Changed Type"

     

    You will see {"Order No", Int64.Type} replace with that {"Order No", type number},

    • parry2k's avatar
      parry2k
      Super User
      6 years ago

      Nosh10 can you make sure that once you changed the column to decimal number, make sure decimal point value is not zero, make it 1 or 2, depending on your needs:

       

       

      I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!