Forum Discussion

maronis's avatar
maronis
Helper I
9 years ago
Solved

Showing multiple text values in a matrix

Hey all, I'm trying to use PowerBI to create a 'nine-box' report - basically, a matrix where you have 'performance' on one axis, 'potential' on the other axis and then you have names of individual em...
  • Anonymous's avatar
    Anonymous
    9 years ago

    Hi maronis,

    Create a measure in your table using DAX below.

    Measure = CONCATENATEX (VALUES(Table1[Employee Name]), Table1[Employee Name], ", ")

    Then create Matrix visual as shown in  the following screenshot and you will get expected result.

     

    Thanks,
    Lydia Zhang

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Solved by adding UNICHAR(10):

 

Measure = CONCATENATEX (VALUES(Merge1[Assignments.ProjectName]),Merge1[Assignments.ProjectName], UNICHAR(10))
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi,

 

This has helped me a lot and is exactly what I was looking for. However, I am having a peculiar issue with this in my matrix. My matrix cells are not displaying the entire value of the concatenation by default. I can see the values when I hover over the cell in the tooltip but they dont show up by default. This is even more pronounced when I filter the visuals using slicers. Some values just get dropped off from the visual and I have to manually adjust the column width repeatedly to show them. Clearly adjusting column width is not an optimal solution for the users. Any help would be appreciated,

 

Thank you,

Leena