Question about Matrix Data Representation and Text Fields

Hi Anonymous ,

You can flexibly create visualizations of text string outputs using ConcatenateX function.  The syntax is super-simple, and it is my favorite dax function.  

https://learn.microsoft.com/en-us/dax/concatenatex-function-dax

Best regards,

Hi Anonymous 
Unfortunately matrix isn't support unaggregated values. 
There is an idea about this issue you can vote for it by the link :
https://ideas.fabric.microsoft.com/ideas/idea/?ideaid=2f4885a2-e130-4852-aefc-8d032c09249b

As an alternative, you can try to create a measure using concatenateX .
(Will work not bad id there is not much data on the cell level)

Something like this with a comma :

Categories = CONCATENATEX(values('Products'[Category]),[Category],",")

OR with unichar (10 )to see every value on another row:

Categories 2 = CONCATENATEX(values('Products'[Category]),[Category],UNICHAR(10))

pbix is attached

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.