Forum Discussion
Helper IList of Values as Visual
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
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.
3 Replies
- Vvelarde
Community Champion
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
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
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.
