Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

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 ...
Need Help
  • mahoneypat's avatar
    mahoneypat
    6 years ago

    You can make a measure that keeps the desired # of characters to show.  For example,

     

    TableText = LEFT(MIN(Table[TextColumn]), 50)

     

    Regards,

    Pat

     

mahoneypat's avatar
mahoneypat
Icon for Microsoft Employee rankMicrosoft Employee
6 years ago

You can make a measure that keeps the desired # of characters to show.  For example,

 

TableText = LEFT(MIN(Table[TextColumn]), 50)

 

Regards,

Pat

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Is there not a way to keep the original text as I would like the full text to be available when I export the table (selection of all data) to CSV. So instead of cutting the text off is it possible to just visually make it look something like: "start text ... end text" ?