Show multiple values of an attribute in one "cell" in a matrix or table visual

[sjhand]

Hi there,

My dataset contains Line Numbers and its various attributes. Line Numbers can repeat, albeit with different values for attributes.

I have generated a list of unique line numbers and now want to look up the attribute values in one "cell". Currently the Line Number repeats in the visual when there is more than one value in a subsequent attribute.

Example:

PowerBI shows Line Number 951-992-7510 twice because it found two statuses for it (first screenshot). I want to show both statuses in one cell (see the second screenshot).

Is this possible in a matrix or a table? If so, how can I make it happen?

[v-yueyunzh-msft · Accepted solution]

Hi , @sjhand 

According to your description, you want to "Show multiple values of an attribute in one "cell" in a matrix or table visual".

Here are the steps you can refer to :

(1)This is my test data:

(2)We can create a measure:

Measure = CONCATENATEX(DISTINCT('Table'[Line Status]) , [Line Status] ,",")

(3)Then we can put the measure and the  [Line Number] on the visual and we will meet your need:

Thank you for your time and sharing, and thank you for your support and understanding of PowerBI! 

Best Regards,

Aniya Zhang

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

[sjhand]

Thank you. This was exactly what I needed to resolve my original question.

I had another follow up. Right now with this function, if 'Active' repeats twice for a Line Number it only shows up once in the result. Is it somehow possible for me to show each value as many times as it repeats for each Line Number?

[vicky_]

I think you can create a measure using the CONCATENATEX() function, and use that instead of the Line Status in your matrix / table. 
The first example here looks quite similar to what you want: https://dax.guide/concatenatex/

[sjhand]

Thank you @vicky_ I had to use this function to get my result.