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

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare 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
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

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