Reply
enlamparter
Helper I
Helper I

List of Values as Visual

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

DataData

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 OptionPreferred OptionAlternative OptionAlternative Option

1 ACCEPTED SOLUTION
Greg_Deckler
Super User
Super User

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...

View solution in original post

3 REPLIES 3
Vvelarde
Community Champion
Community Champion

@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:

 

Img3.png

 

Regards

 

Victor




Lima - Peru

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
Super User
Super User

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...
avatar user

Helpful resources

Announcements
March PBI video - carousel

Power BI Monthly Update - March 2025

Check out the March 2025 Power BI update to learn about new features.

March2025 Carousel

Fabric Community Update - March 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)