Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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
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
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
105 | |
96 | |
75 | |
63 | |
62 |
User | Count |
---|---|
137 | |
105 | |
104 | |
80 | |
63 |