Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I need to produce a list of people who know each software. My data looks like this:
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?
Solved! Go to 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.
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
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
99 | |
80 | |
70 | |
59 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |