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,

Could you please share sample data of your table and post expected result here?

Thanks,
Lydia Zhang

maronis's avatar
maronis
Helper I
9 years ago

Absolutely. So I'm hoping to take data that looks like the below where there is a Performance rating and Potential value for each employee:

And the output should be a matrix that looks something like below, where Performance is on one axis, Potential is on another axis, and all values for each box in the matrix are populated.

 

 

Thanks so much for your help!

  • 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

    • maronis's avatar
      maronis
      Helper I
      9 years ago

      Awesome, thanks so much!

    • smpa01's avatar
      smpa01
      Community Champion
      8 years ago

      This is awesome !!!

    • 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