List of Values as Visual

[enlamparter]

I need to produce a list of people who know each software. My data looks like this:

Data

I need it to look like this or the second option (but the first is preferred). Is there a way to do this in a matrix or table visual?

Preferred OptionAlternative Option

[Vvelarde]

@enlamparter

Hi, the first one you can obtain with:

PeopleList = CONCATENATEX(VALUES(Table1[People]);Table1[People];"
    ") 

After The First " PRESS SHIFT+ENTER

And in a matrix visual:

Regards

Victor

[Dano001]

I tried your DAX function (for Option 1) and all i get in peoplelist column is a concatenated list of all people, for each record. Is your DAX function parameters correct?

i also had to use "," and not ";" as delimeters

[Greg_Deckler · Accepted solution]

You can do the second one by using a matrix and putting Software and Person into the Rows area in that order and then drilling down using the forked arrow icon.