[DataFormat.Error] We couldn't convert to Number.

[Anonymous]

Hi everyone, i'm trying to do some data transformations with my data. But when I try to drop down the filter, it's showing data format error. The column is of "Text" type. But I don't understand why does it throw error regarding number. Can anyone please help? 

I have added the snapshot for reference.

Thanks

[PijushRoy · Accepted solution]

Hi @Anonymous 

May be there are some special character/non supported character
To handle this situation,
1. Please insert Index into the table

2. Then select the column and Replace error with specific value, example 55555

3. After the replace value, filter the table with value you replace (example 55555)
4. Now check the Index of the the Row
5. Go to Power Query earlier step and check the value whcih cause error and correct the error value. After correct the value in your source file, you can delete the steps you made for error checking.

I hope you understand the process, please let me know

If solve your requirement, please mark this answer as SOLUTION
If this comment helps you, please LIKE this comment/Kudos

[claymcooper]

It's not coverting to Number because you have letters in the column. The only way to change it to a number is to remove those letters or taking out the number portion by using delimiters.