The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
How can I remove = sign from these below columns and changed the data type from text to whole number or decimal? This is a dataset that I have imported through Web Query.
I clicked on the Abc and changed to whole number but it gave ERROR.
Solved! Go to Solution.
Hey @learner03 ,
before you change it you have to get rid of the equal sign.
For that select the column, go to Transform --> Replace Values:
Then in the dialog replace the equal sign with nothing:
Afterwards you can change the type to whole number.
Hey @learner03 ,
before you change it you have to get rid of the equal sign.
For that select the column, go to Transform --> Replace Values:
Then in the dialog replace the equal sign with nothing:
Afterwards you can change the type to whole number.