Forum Discussion

CraigBlackman's avatar
CraigBlackman
Icon for Helper III rankHelper III
10 years ago
Solved

Multiple lines text in a table or Matrix

Hi,   I am using the matrix or table to display data. In excel and it will display the text in multiple row, In power BI as 1 contiunous line which is no good.   Anyone know a way around this? Th...
Need Help
Tips and Tricks
  • CraigBlackman's avatar
    CraigBlackman
    10 years ago

    Anonymous, it appears not to be SQL related but a direct issue with PowerBI.

     

    I have made contact witht hem and they are activly looking into this.

     

    My way around this for now is to pull the data into a pivot table in Excel and use the workbook function now available in BI, not ideal but a work around.

     

    Thanks for your help.

CraigBlackman's avatar
CraigBlackman
Icon for Helper III rankHelper III
10 years ago

Hi Anonymous,

 

It is one field thats wrapped up into 1 line, not the whole table.

 

It appears that the associated field in our SQL database uses a double space as the new line identifier.

 

Thanks

 

Craig