Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Shape the future of the Fabric Community! Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions. Take survey.

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

Helpful resources

Announcements
November Carousel

Fabric Community Update - November 2024

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

Dec Fabric Community Survey

We want your feedback!

Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.