Forum Discussion
BI replace value function automatically add special character while replacing.
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:
- By right clicking on the selected column selected Transform -> Clean it also not helped me
- 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
Hi HassanMoosa ,
Check a similar thread which may help:
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,
KellyDid I answer your question? Mark my post as a solution!
3 Replies
- lbendlinSuper User
Not clear what the actual issue is, but have you tried Character.FromNumber(160) instead?
- v-kelly-msftCommunity Support
Hi HassanMoosa ,
Check a similar thread which may help:
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,
KellyDid I answer your question? Mark my post as a solution!
- AnonymousNot applicable
You could just uncheck the Replace Using Special Characters though right?