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
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

nrenaud's avatar
nrenaud
Helper I
7 years ago

Thanks for this! Is there a way to do this DAX, but also add an addition text field next to the name? For instance, the result would look like:

"NAME" + "another field with additional info"

 

I was thinking the DAX could look something like: Measure = CONCATENATEX (VALUES(Table1[Employee Name]), Table1[Employee Name] + (Table1[Additional Info]), ", ") -- this doesn't work, but is something similar to this possible?

 

Thanks!

Nicole