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 way to cut off the text so that every row is just 1 line? It's a table visualisation. Thanks!
You can make a measure that keeps the desired # of characters to show. For example,
TableText = LEFT(MIN(Table[TextColumn]), 50)
Regards,
Pat
3 Replies
You can make a measure that keeps the desired # of characters to show. For example,
TableText = LEFT(MIN(Table[TextColumn]), 50)
Regards,
Pat
are 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
