Forum Discussion

maronis's avatar
maronis
Icon for Helper I rankHelper 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

tonyrutt's avatar
tonyrutt
Frequent Visitor
5 years ago

This was a super helpful answer that enabled me to add additonal values into a grid. However is there a way to add additional rows? We have mutliple promotions to the same customer on the same day, I want to break those out onto separate lines for each customer while still retaining the concatenation to have multiple values in the grid.  In essence what I have is this, what I want to add are the lines in red. Thanks in advance for any suggestions.