How to Fix raw width

[irenelitw629]

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

[v-easonf-msft]

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

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]

@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.