The apostrophe character in a table visual shows as '

[paalvarez]

These come from text fields used for comments in a SharePoint list. We are summarizing these in the Power BI report.

Is there a way to replace ' with ' on the fly as they appear in the report? Words like can't, won't, shouldn't are used in in comments and they all show as  can't, won'', shouldn't.

I can manually find and replace them, but it would be better if there was a rule of some kind that would do this replace function as they are encountered.  

Thanks in advance!

[amitchandak · Accepted solution]

@paalvarez , In power query you can do using the menu item on right click has an option

Or use text.replace

Text.Replace(text as nullable text, old as text, new as text) as nullable text

https://www.howtoexcel.org/power-query/bulk-replace-values/

[paalvarez]

Thanks to all for the replies.

Amitchandak, this worked. My concern was that when the ' would appear again after the data refresh, and it did not after I did this Replace function. Mission accomplished!

Thanks again

[darentengmfs]

Hi @paalvarez 

If I understand this correctly, you can replace them in Power Query. Go to Power Query Editor, click the column you want to replace, and choose Replace Values.