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

smpa01's avatar
smpa01
Community Champion
8 years ago

AnonymousI ran into a similar problem and then found this post which solved my problem. I wanted to see how far dyanmic this formula is and it surprised me.

 

I created a sample table to tase it on two CATs and it succedded in both the cases.

 

I was wondering if you can please shed some light on this to help me understand how does the formula works on parts. It is simply great. I fail to understand how the formula slices up values based on the different CATs