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!