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

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hello, 

     

    How can I add a line break in between values instead of having them all on the same line?

     

     

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Solved by adding UNICHAR(10):

       

      Measure = CONCATENATEX (VALUES(Merge1[Assignments.ProjectName]),Merge1[Assignments.ProjectName], UNICHAR(10))
      • Anonymous's avatar
        Anonymous
        Not applicable
        4 years ago

        Hi,

         

        This has helped me a lot and is exactly what I was looking for. However, I am having a peculiar issue with this in my matrix. My matrix cells are not displaying the entire value of the concatenation by default. I can see the values when I hover over the cell in the tooltip but they dont show up by default. This is even more pronounced when I filter the visuals using slicers. Some values just get dropped off from the visual and I have to manually adjust the column width repeatedly to show them. Clearly adjusting column width is not an optimal solution for the users. Any help would be appreciated,

         

        Thank you,

        Leena

  • 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