- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
List 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 Option
Alternative Option
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: Power BI Cookbook Third Edition (Color)
DAX is easy, CALCULATE makes DAX hard...
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
Lima - Peru
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: Power BI Cookbook Third Edition (Color)
DAX is easy, CALCULATE makes DAX hard...

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
02-02-2024 08:46 AM | |||
Anonymous
| 12-15-2023 01:13 AM | ||
06-06-2024 07:09 AM | |||
09-18-2024 04:35 PM | |||
05-26-2024 05:53 PM |
User | Count |
---|---|
140 | |
110 | |
81 | |
60 | |
46 |