Forum Discussion
Power Bi not recognizing same text in a column
Hello everyone, So im having this problem: I have a column with the status of different projects: i.e In progress, Completed, etc: But, I want to replace some status text for other tex...
Before you do the Remove Duplicates step, try two transformations:
- Right-click on the column and do Transform, Trim. This will remove any leading and trailing spaces. Visually to you they look identical, but they aren't. Then do the Remove Duplicates.
- If they are still showing up twice, remove the Remove Duplicates step, then right-click on the column and do Transform, Clean. This will remove any special non-printing characters, like a carraige return or the Char(160) space.
If that still doesn't work, in the PQ window, click on each value you think should be the same and look in the window below. You can even select that data and put it in something like NotePad++ and try and figure out what else is in there.
For example:
No extra spaces4 trailing spaces
In the table, these look the same, but when I click on each and highlight below, I can see there are trailing spaces on the 2nd entry, and PQ will not remove that as a duplicate until you TRIM it.