Table Visual - Not displaying all values with text wrap

[Power-MC]

I am currently working with a table visual, however for one column in particular only some of the values are displayed. The other columns in each row display as normal, whereas for this column there is a mix of values and whitespace (every column should contain a value). When I hover over the seemingly empty cell, a popup shows the value in question.  

I have tried adjusting the column width, but this has not changed the output. By going to format --> values --> and turning off text wrap I am able to see the values in question, but I am curious as to why this is. 

[RichardJ · Accepted solution]

Hi @Power-MC, it might be worth using notepad ++ and the show all characters option to find out if there are any special/odd characters in the strings which are not displaying.

if you copy some of the text which is not displaying into notepad ++ and use the option above then paste an example back here we may be able to help


it may be carriage returns in your string that are making the column appear blank unless hovered over.

[Power-MC]

Hi @RichardJ you are right, there were special characters within the cell affecting the output, specifically #(tab)#(lf). After removing these characters, the data displays as normal. Thank you for your help.