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.
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.
Helpful resources
FabCon Global Hackathon
Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!
Power BI Monthly Update - September 2025
Check out the September 2025 Power BI update to learn about new features.
FabCon Atlanta 2026
Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
