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. 

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.