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 employees in each box based on their performance/potential ratings.

 

In PowerBI, I can create a matrix that will display the first name in each box, but I can't figure out if there's a way to use the Matrix visualization to display every value that matches the criteria for that box in the matrix. Any ideas on how I can do this? Thanks!

  • 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

11 Replies

  • 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

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