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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
kkanda
Resolver I
Resolver I

Table visual Cells Values word wrap is on but not working

Hi All,

I inserted a table in the visual and included columns of data from the data source. One of the columns has a long text and the text is not gettting wrapped in the cells. I only see characters in one line only.

I am using the Desktop Oct 2020 version. I checked the Formatting options of the table and under Values, I see the Word Wrap selection is on. I am able to change the font size etc, but the word wrap does not seem to be having any effect.

Can anyone advise me what to do? I want to show all the text from the data source in multiple lines in the table, so that when I export the table the data is complete.

Thanks in advance

1 ACCEPTED SOLUTION
v-yangliu-msft
Community Support
Community Support

Hi  @kkanda  ,

You can upgrade the version of power bi desktop to the latest version

My current version is the following picture

v-yangliu-msft_0-1614904975964.png

Can automatically wrap:

v-yangliu-msft_1-1614904975968.png

This is the URL to view the latest version and download of Dsketop:

https://www.microsoft.com/en-us/download/details.aspx?id=58494

https://docs.microsoft.com/en-us/power-bi/fundamentals/desktop-latest-update

 

 

Best Regards,

Liu Yang

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

View solution in original post

5 REPLIES 5
v-yangliu-msft
Community Support
Community Support

Hi  @kkanda  ,

You can upgrade the version of power bi desktop to the latest version

My current version is the following picture

v-yangliu-msft_0-1614904975964.png

Can automatically wrap:

v-yangliu-msft_1-1614904975968.png

This is the URL to view the latest version and download of Dsketop:

https://www.microsoft.com/en-us/download/details.aspx?id=58494

https://docs.microsoft.com/en-us/power-bi/fundamentals/desktop-latest-update

 

 

Best Regards,

Liu Yang

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

Hello yangliu,

On further investigation, I found that my current version or Power Bi (Oct 2020) does wrap the text in table cells by selecting Word Wrap. I selected Word Wrap for Values and then increased the Font size of the text. Then it works.

Problem appears that the SAP BW App Analyzer is not providing full text to Power BI (or the import feature of Power BI from SAP BW App Analyzer) as I do not see the full text on the Preview window while uploading data from SAP. When the Cube is opened in Excel interface, however, all the text is imported with Word Wrap feature in Excel workbook. So the problem may not get solved by upgrading to Feb 2021 version. 

Does the Feb 2021 version includes any change in the data input from SAP?

kkanda
Resolver I
Resolver I

@negi007 -- Thanks for the response. The following are the screenshots for the settings for Column Headers and Values for the Table.

kkanda_0-1614827623809.png

The problem is with the cells in the Values section of the Table. I want them to wrap the long text  and show the entire content... which is not happening now.

krishna

negi007
Community Champion
Community Champion

@kkanda Word wrap selection On is used when you do not want row headers to appear in multiple lines. It does not impact the data that you export. Your complete data will get exported even if Word wrap is off or on.  I hope you have selected below option on your table visual. Please share your visual screenshot or data to assist you further.

 

negi007_0-1614785271854.png

 

 




Did I answer your question? Mark my post as a solution!
Appreciate your Kudos



Proud to be a Super User!


Follow me on linkedin

The text in the referred column is showing truncated text in the Editor view even though the Excel workbook (which is the data source for this visual) shows the complete text with word wrap feature.  I downloaded the Excel workbook from SAP Business Objects  separately and created a test Power BI visual with only the Table included. The referred column in the Table displays the full text in word wrap format. I cannot make out why the text is getting truncated in the first visual.

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

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