Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 |
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.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
97 | |
85 | |
67 | |
59 |
User | Count |
---|---|
150 | |
120 | |
100 | |
87 | |
68 |