Forum Discussion

irenelitw629's avatar
irenelitw629
Helper II
6 years ago

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

Need Help

2 Replies

  • v-easonf-msft's avatar
    v-easonf-msft
    Community Support
    6 years ago

    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's avatar
      irenelitw629
      Helper II
      6 years ago

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