Forum Discussion
Data Format Error
parry2k I've managed to solve now. It looks as though an error was created during earlier stages where I split a column, changed their formats and carried out some data cleansing, and re-merged them, changing their format a final time. Once these steps had been removed, the changes were applied without problem.
Thank you for your time and effort in helping
Anonymous so basically there is a column that is converted to a number with the text value. if you have multiple columns that are getting converted to number, change their type to text and change type of one column to number at a time to see which column is giving the error.
Check my latest blog post Comparing Selected Client With Other Top N Clients | PeryTUS I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡
parry2k I only have one column which is set as a number format and having checked this both in Power BI using the search filter, as well as the original data set in Excel, I can't find the error