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, but nothing changed. Please see attached. 

 

 

Need Help
  • Nosh10's avatar
    Nosh10
    6 years ago

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

10 Replies

  • camargos88's avatar
    camargos88
    Community Champion
    6 years ago

    Hi Nosh10 ,

     

    Check on Query Editor the steps converting data types, perhaps it's converting there. If yes, just change the type.

    • Nosh10's avatar
      Nosh10
      Helper II
      6 years ago

      Hi! Thanks. I changed the data type in the query editor as well, and no luck. Can you provide any work arounds?

      • 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.

  • v-yingjl's avatar
    v-yingjl
    Community Support
    6 years ago

    Hi Nosh10 ,

    It seems like you have changed the data type and adjusted the number of decimal places in power bi desktop, it looks like normal.

    Did you mean it not work in the filter like the yellow part?

    If so, when the initial data is 1,2,3.. , even if you change the data type as decimal number, it will not reflect in power query editor and data view filter. However, you can see the 1.0, 2.0, 3.0 ... in the slicer visual.

    data view filter will not reflect the initial 1 as 1.0slicer can do it

    Best Regards,
    Yingjie Li

    If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

    • Nosh10's avatar
      Nosh10
      Helper II
      6 years ago

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

  • Syndicate_Admin's avatar
    Syndicate_Admin
    Administrator
    5 years ago

    Hi @Nosh10 ,

    It looks like you've changed the data type and adjusted the number of decimal places on the power bi desktop, it looks normal.

    decimal.png

    Do you mean it doesn't work in the filter like the yellow part?

    If so, when the initial data is 1,2,3.. , even if you change the data type as a decimal number, it will not be reflected in the power query editor and the data view filter. However, you can see the 1.0, 2.0, 3.0 ... in the slicer visual.

    data view filter.pngData view filter will not reflect the initial 1 as 1.0slicer.pngcutter can do it

    Best looks,
    Yingjie Li

    If this post helps, please consider Accepting it as the solution to help other members find it more quickly.