Forum Discussion

randomuserista's avatar
randomuserista
New Member
1 year ago
Solved

Matrix : display all values

Hi all,   I would like to create a visual priority matrix in Power BI, the minimum I would like to do is this : So I put "Business Value" in Row; "Complexity" in Columns and the "ID" i...
  • ibarrau's avatar
    1 year ago

    Hi. You can do it. Create a new measure to use it as values. The measure can use CONCATENATEX to combine all the values separated by a delimiter. That way you could show them all with a space or comma. Something like:

     

    = CONCATENATEX(Employees, Employees[FirstName] & " " & Employees[LastName], ",")

     

    You can read more about concatenatex here: https://dax.guide/concatenatex/

    I hope that helps,