Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.

Reply
Power-MC
New Member

Table Visual - Not displaying all values with text wrap

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. 

1 ACCEPTED SOLUTION
RichardJ
Responsive Resident
Responsive Resident

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

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

View solution in original post

2 REPLIES 2
RichardJ
Responsive Resident
Responsive Resident

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

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

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.

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.