Forum Discussion
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...
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.
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 will not reflect the initial 1 as 1.0
cutter 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.