An entire column shows 100% error when i close and apply

lllanre if you click the white space in the error cell, it will show the details in a window below. Could you share what that message is?

lllanre 
1. Can you try converting USD Price column to a number format (Changed Type1) and In the next step to Currency (Changed Type2) ?
2. Try checking with the latest data. Click Refresh Preview 

Thanks,

Jai

Hey, lllanre ,
I would assume that your original column is either having some rows with text, or you have incorrect culture settings, for example mismatch between comma-delimited, like "." and ",". I would check that first, fix it and then try to change the type again. 

Also, the easiest way to know what's wrong is to click next to the error in a 'cell' in the grey area.

Hi lllanre ,

Thanks for reaching out to Microsoft Fabric Community.

Just checking in to see if you had a chance to look into the suggestions shared by vojtechsima , Jai-Rathinavel and parry2k . Also as mentioned earlier, if you can share the error details shown in the bottom pane when selecting any of the error cells, it will help identify what is causing the error.

Thank you.

Hi lllanre ,
We wanted to kindly follow up regarding your query. If you need any further assistance, please reach out.
Thank you.