Forum Discussion
Wrap text in specific columns?
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?
Hi Anonymous ,
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
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.
12 Replies
- gmsamborn
Super User
Hi Anonymous
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/14475233) 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.
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.
v-dineshyaCommunity Support
Hi Anonymous ,
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 Anonymous ,
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.
Thank you for asking, not quite yet though. Additional details on my query are in my responce to gmsamborn.
Thanks,
Will
