Forum Discussion
Query error editor
Hi Anonymous,
Please change the data type of that field from "Any" to "Text" before replacing values. Then, you can replace "-" with "0" or empty. After replacing, you can change the data type to "Whole number".
Best regards,
Yuliana Gu
Anonymous
Probably it is not the '-' that you need to replace but it is the blanks.
So in find replace leave the find text with no value and the replace text with 0
Anonymous
It is an error message which means that there is something wrong with this field.
It is not a text that can be replaced.
You have to fix the error message. You need to find out what is causing it.
The word 'error' is not a value in the column but rather a message from the software.
I hope it makes sense.
Anonymous
Are you trying to replace a value in the field which displays the error message?
Yes i did try that also.
Anonymous
I mean if the field you are trying to replace the values has errors, then maybe it's best to fix the errors first??
Yes themistoklis this is what i try too do. the error is there because its not a number. So i want to replace that value with something els. but the question is how ?
themistoklisi try too explain that its a error in the field that is cause by the value field. In this case '*' or '####' or '-'
it is a text that is placed in a cell that is a part of a number column.
i understand that error is not a value in the cell
I have noticed that power bi table removed all '-' values except for 2 cells that have a cell property in the source excel as a number.
the other '-' values have in the source excel table a property as standard.