BI replace value function automatically add special character while replacing.

[HassanMoosa]

Hi all, I replaced value using bulit in function but BI automatically selects replace using speacial character and then selects non-breaking space.  Can anyone guide me how can I set clean my data in a way that this not happens.  Or if I leave it as it is can this make any issues regarding further calculations?  For more information you can see the screenshot. 

The fix I tried till now is as fallow:

1.  By right clicking on the selected column selected Transform -> Clean it also not helped me
2. I tried to follow  text-removebetweendelimiters-function-for-power-bi-and-power-query  but was unable to implement successfully.  

My table name is: Combine_Feedback

My Column Name is: IL

[Anonymous]

You could just uncheck the Replace Using Special Characters though right? 

[v-kelly-msft · Accepted solution]

Hi  @HassanMoosa ,

Check a similar thread which may help:

https://social.technet.microsoft.com/Forums/ie/en-US/a78442d1-584e-464e-b1d4-c512746bfa25/how-to-rep...

Or Check the blog below for bulk replace values in power query:

https://www.syntelli.com/easy-guide-to-bulk-replace-values-in-power-bi-or-power-query

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

[lbendlin]

Not clear what the actual issue is, but have you tried Character.FromNumber(160)  instead?