Forum Discussion
Matrix Table Not Showing Multiple Values
Anonymous ,
I'm trying to take a dataset that has two dimensions (project phase and service line) and show all individual projects (text values) aligned to each combination of the dimensions. Unfortunately all I'm able to see if one value per combination. Is there a way to have all values shown?
So your requirement is to show all related values in a matrix cell, right? To be general, you can create a measure using CONCATENATEX() function then drag the measure to the value field of the matrix visual.
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks for the suggestion. I'm able to create a quick measure that gets all the values together through concatenation but unfortunately I'm not able to place a carriage return between each project name so the output isn't formatted the way I'd like to show it visually.
Anonymous ,
Anonymous wrote:
Thanks for the suggestion. I'm able to create a quick measure that gets all the values together through concatenation but unfortunately I'm not able to place a carriage return between each project name so the output isn't formatted the way I'd like to show it visually.
Could you show more details about the logic of "carriage return" and your expected results?
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.