Forum Discussion
Cut off text in table visualisation
Hi All, I have a table in PowerBI desktop that shows some information about some columns. A few of those columns contain quite some text, making the table unreasonably huge ( 8-10 lines). Is there a ...
You can make a measure that keeps the desired # of characters to show. For example,
TableText = LEFT(MIN(Table[TextColumn]), 50)
Regards,
Pat
vanessafvg
Community Champion
Community Championare you wanting to make it smaller in power query? you could limit it using
Text.Start(fieldname, 200) in power query as an example that would filter it out the model
https://docs.microsoft.com/en-us/powerquery-m/text-start
or you can use dax to filter it out the visual in a calculated column ie
using the left function
https://docs.microsoft.com/en-us/dax/left-function-dax