Issues with Text Wrap

[z_mike_90]

I have a table visual where the text wrap in a column is turned on.  However, there is an issue with carriage returns being automatically inserted when the column size decreases:

When I increase the size of the column width, the carriage returns are gone.  I checked the text and I don't see any ascii values.  I only see the returns with the dynamic sizing of the column.  Expanding the width of the column is not the option I want due to lack of real estate on the table.

How do I correct the text formatting?

[z_mike_90]

Hi Zhengdong,

That worked.  Thanks for your help.

[Anonymous · Accepted solution]

Hi @z_mike_90 

Given you've mentioned that you have open the text wrap.

So I speculate that maybe there are some non-visible characters in your data, although you mentioned not seeing any ASCII values, it might be helpful to double-check your data for any non-visible characters that could be interpreted as carriage returns. Sometimes, data imported from external sources can contain hidden characters.

Maybe you can try this function in power query which returns a text value with all control characters of removed:

Text.Clean()

Text.Clean - PowerQuery M | Microsoft Learn

Best Regards

Zhengdong Xu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.