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. 

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.