Discount column values change to 0 after loading from Power Query to Power BI

Hi. Can you share your power query code to make sure there isn't something odd there. Usually when showing 0 it's a decimal thing, data type o coma place. But this time looks kind of good. Make sure data types are correct, click at the column once the data model has refreshed and check it. Try adding decimals shown in a visual to check if there is not a problem that the number is before two decimals like 0.0015. We can check better with power query.

Regards,

hi Beatrice_Wambui, 

Without the Power Query example this one is a little hard to diagnose. But, what you can try is to check in the Power BI Report (not Power Query) that there is not any rounding on that field. Just select the Discount column in your data pane and go to the Column Setting ribbon at the top. 

I would check through all of this and make sure it is correct. Some changes on the Front end of Power BI Desktop don't always push back to Power Query.