Rowbrake between values when using List of value in a matrix (new quick measure)

[Mstrande]

Hi,

Today I found that its possibly to do a quick measure and choose text and concatenate which means that the Matrix (pivot) shows all values in the cell and not only the first. great.

But do anyone now how to get a row break between these values?

It shows the data like this in a cell

Value A, Value B, value C

I want

ValueA

Value B

Value C

I tried to use wrap text and narrov the columns but the textvalues has a dfferent length so it didnt work.

Br

Mattias

[v-cherch-msft · Accepted solution]

Hi @Mstrande 

You may add a measure with UNICHAR function in matrix as below:

Measure = CONCATENATEX(Table1,Table1[Value],UNICHAR(10))

Regards,

[Mstrande · Accepted solution]

Hi,

thanks for the answer, looks promising.  My formula looks like below in a measured column where technical content level 2 is my values that need to be sorted with a row brake, line brake, "return" between each value. Can you guide how to implement your formula?

/Mstrande

[v-cherch-msft · Accepted solution]

Hi @Mstrande 

You may add a measure with UNICHAR function in matrix as below:

Measure = CONCATENATEX(Table1,Table1[Value],UNICHAR(10))

Regards,

[v-cherch-msft · Accepted solution]

Hi @Mstrande 

Please replace the delimiter "," of CONCATENATEX Function in your formula with UNICHAR(10).

Measure = CONCATENATEX(Table1,Table1[Value],UNICHAR(10))

Regards,

[Mstrande]

Thanks for this, so great.

/M

[Mstrande · Accepted solution]

Hi,

thanks for the answer, looks promising.  My formula looks like below in a measured column where technical content level 2 is my values that need to be sorted with a row brake, line brake, "return" between each value. Can you guide how to implement your formula?

/Mstrande