Creating rows within a a cell.

[cmckinney]

Hi,

I am trying to make so that each cell in the following table shows each word with a separate line within a cell. Here is a screen shot of how it currently looks followed by a screen shot from Excel of how I want it to look.

[v-zhenbw-msft]

Hi @cmckinney ,

How about the result after you follow the suggestions mentioned in my original post?

Could you please provide more details or expected result about it If it doesn't meet your requirement?

If you've fixed the issue on your own please kindly share your solution. If the above posts help, please kindly mark it as a solution to help others find it more quickly.

Best regards,

Community Support Team _ zhenbw

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[mahoneypat]

You can use CONCATENATEX with a carriage return in the delimiter to get that effect.  Is your current measure using CONCATENATEX? or is it still a long text string?  If the latter, you'll likely want to split the text and unpivot in the query editor, so that you can concatenate it with more flexibility.

If this works for you, please mark it as the solution.  Kudos are appreciated too.  Please let me know if not.

Regards,

Pat

[cmckinney]

@mahoneypat 

Thank you for the reply. The data type for the column is text. I would just split it by delimeter then pivot like you said but the query needs to be in "DirectQuery" mode and not in "Import" mode. It wont allow for the data to stay in "Direct Query" if you split the columns by delimeter. 

[v-zhenbw-msft · Accepted solution]

Hi @cmckinney ,

The split function is not supported in Direct Query mode.

Please refer to Direct Query limitations.

https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-directquery-about

If your data source is SQL Server, maybe you can use SQL statements to pre-process when connecting to data sources.

https://docs.microsoft.com/en-us/sql/t-sql/functions/string-split-transact-sql?view=sql-server-ver15...

Best regards,

Community Support Team _ zhenbw

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

HI @cmckinney 

As per your explanation, you have to work on the query whic you have written to be uses as a direct query.

This is not a Power BI issue rather you may think about asking help from someone who can get the query to return as required on the Datasource you are pulling it from.