cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
irenelitw629 Helper I
Helper I

How to Fix raw width

Hi,

 

Anyone can advice me how to fix  raw width? I have a column which contains lot of txt and I don't want to show them all.

 

For example here is the data:

Sales Update
xxxxxxxxxxxxxxxxxoooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooo

 

I want to display partial txt only while maintaining the same row width:

 

Sales Update
xxxxxxxxxxxxxxxxx

 

I tried to turn off auto-size column and turn on wrap txt...however the result ( as per below)is not what i want:

Sales Update

xxxxxxxxxxxxxxxxx

ooooooooooooo

ooooooooooooo

ooooooooooooo

ooooooooooooo

2 REPLIES 2
Microsoft v-easonf-msft
Microsoft

Re: How to Fix raw width

Hi , @irenelitw629 

 

I  tried to use custom format strings in Power BI Desktop,but failed.

Url: https://docs.microsoft.com/en-us/power-bi/desktop-custom-format-strings

 

But I have an alternative method not sure if it works for you.

Try the function of "Extract" in Transform

01.png

02.png

03.png

 

The bad point of this solution is that it is equivalent to modifying the data, rather than controling the number of strings displayed in visual.

 

Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

irenelitw629 Helper I
Helper I

Re: How to Fix raw width

@v-easonf-msft,

 

Thank you for your reply! I also tried custom format strings before.  Extract is not what i need...I still need to disaplay the entire string when i hover over the cell.

 

 

Helpful resources

Announcements
New Ranks Launched March 24th!

New Ranks Launched March 24th!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power BI Community!

‘Better Together’ Contest Finalists Announced!

‘Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

Arun 'Triple A' Event Video, Q&A, and Slides

Arun 'Triple A' Event Video, Q&A, and Slides

Missed the Arun 'Triple A' event or want to revisit it? We've got you covered! Check out the video, Q&A, and slides now.

Join THE global Microsoft Power Platform event series.

Join THE global Power Platform event series.

Attend for two days of expert-led learning and innovation on topics like AI and Analytics, powered by Dynamic Communities.

Community Summit North America

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors