Matrix Visual

[dhaley]

Hello,

I am trying to set up a visual that will list a category by row, quarters in the columns and the actual list of names in the values instead of the count of names.  I am searching everywhere and reading through a ton of submissions on this board but not finding anything. I am open to using any visualization but this is what I have using the Matrix:

Is there a way to convert the numbers into the actual list of names?

Thanks

[v-luwang-msft]

Hi @dhaley ,

You may need to enable the "Show items with no data" option for the rows of Matrix visual.

And I have a test ,see the below:

Wish it is helpful for you!

Best Regards

Lucien

[mahoneypat]

You can try this measure expression

ListOfNames = CONCATENATEX(VALUES(Table[ColumnOfNames]), Table[ColumnOfNames], "

")

The carriage return is intentional above, so that each name is on a new line.  You can replace with "," or whatever delimiter you want.

Pat

[parry2k]

@dhaley you can create a measure that will concatenate the names but it will not look pretty. 

✨ Follow us on LinkedIn

Check my latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡

[dhaley]

Thank you parry2k, I will try that to see how it looks.