Carriage returns from Sharepoint List

Power BI
11

@radley,

Okay, thanks very much for the clear explanation of the requirement with example. Here’s the outcome, with your desired format on the left and my solution on the right:

image
image739×401 8.68 KB

Here’s what I did:

  1. Split the SharePoint list by lowercase to uppercase

  2. Unpivoted the resulting names column

  3. Added an index column (to maintain the name order in the following measure)

  4. Use the CONCATENATEX, UNICHAR(10) trick discussed above in the following measure, to concatenate all the names on a given project with a hard return between them, ordered by the ascending index order:

    CONCATX Name =

     CONCATENATEX(
     'Sharepoint Transformed',
     'Sharepoint Transformed'[Name],
     UNICHAR(10),
     'Sharepoint Transformed'[Index],
     ASC
 )

Then just dropped project and the measure into the table visual. Hopefully, the third times a charm on this one…

Full solution file posted below.