Forum Discussion

HassanMoosa's avatar
HassanMoosa
Helper I
5 years ago
Solved

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:

  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

 

 

3 Replies