Wrap text in specific columns?

[Will_Z939312312]

I saw several post mentioning that this function, was not available from several years ago. Have they implemented it or is it still not possible?

[v-dineshya]

Hi @Will_Z939312312 ,

Thank you for reaching out to the Microsoft Community Forum.

I took sample data to display the table visual data, wrap text enable and disable.

While disable Text wrap, please refer snap.

While Enable Text wrap, please refer snap.

To enable "Text wrap" option, click on selected column on table visual, In format option --> under the "values" option, you will find the "Text wrap" option.

If my response has resolved your query, please mark it as the "Accepted Solution" to assist others. Additionally, a "Kudos" would be appreciated if you found my response helpful.

Thank you

[v-dineshya]

Hi @Will_Z939312312 ,

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet.do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.

Thank you.

[Will_Z939312312]

Thank you for asking, not quite yet though. Additional details on my query are in my responce to @gmsamborn.

Thanks,

Will

[v-dineshya]

Hi @Will_Z939312312 ,

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot). Do not include sensitive information. Do not include anything that is unrelated to the issue or question. Please show the expected outcome based on the sample data you provided.

Thank you

[v-dineshya]

Hi @Will_Z939312312 ,

We haven’t heard from you on the last response and was just checking back to see.

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot). Do not include sensitive information. Do not include anything that is unrelated to the issue or question. Please show the expected outcome based on the sample data you provided.

Thank you

[Will_Z939312312]

Sample data:

The top table is what the table initially looks like(With text wrap) but it was too word heavy and created too much white space.

By disabling text wrap for the bottom table, it solved that problem. But it also created a new one, where the contents of column1 end up being sometimes condenced(With the 3 dots).

I wish to keep text wrap for columns 1 and 3, while turning it off for column 2. 

P.s: If needed I can send the .pbix file

[v-dineshya]

Hi @Will_Z939312312 ,

Please provide the .PBIX file, it will help me to replicate the scenario. 

Regards,

Dinesh

[Will_Z939312312]

Here you are:

https://drive.google.com/file/d/1cLYolQMG23pOEM6QuwTAHi2QFBn0H0Cg/view?usp=drivesdk

[v-dineshya]

Hi @Will_Z939312312 ,

It is not possbile to "turn off wrap per column" in Power BI.  please refer alternative workaround.

Please refer the below steps to fix the issue.

1. Created Calculated column "Column2Short" to Shorten the  text column (Column 2).

with below DAX code.

Column2Short =

IF(LEN([Column2]) > 100,

   LEFT([Column2], 100) & " ...",

   [Column2]

)

2.  I have enabled "Text Wrap" option, and placed the required column in Table visual. Please refer output snap and attached PBIX file.

If my response has resolved your query, please mark it as the "Accepted Solution" to assist others. Additionally, a "Kudos" would be appreciated if you found my response helpful.

Thank you

[v-dineshya · Accepted solution]

Hi @Will_Z939312312 ,

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet.do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.

Thank you.

[gmsamborn]

Hi @Will_Z939312312 

I would like to help but I'm a little unclear about your requirements.

What text to do you want to "wrap" the column in?

Another column's values

Static text

"Dynamic" text

Can you provide the following?

1)  Please provide sample data that covers your issue or question completely.
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...

2) Please show the expected outcome based on the sample data you provided.
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

3) Please explain how you would expect to get from step 1 to 2.

4) If possible, please show your past attempts at a solution.

A .pbix file with sample data would be best.

[Will_Z939312312]

Hello @gmsamborn 

Well it would be more accurate to say that I want the majority of columns in a table to be wrapped while leaving a select few unwrapped. 

This is the table that I want to change(text wrap is on for all columns):

One column's entries are just a gigantic blocks of text, that are making the formatting terrible. My solution is disabling text wrapping which formats the table into this:

Which works, but also makes a few other columns(ex: column 2) that I don't want compressed, compressed. I could somewhat fix this by manually adjusting the columns width, but I want a more dynamic solution by applying text wrap to those specifice columns.