Matrix : display all values

[randomuserista]

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" in Values. However I obtain this :

In values I only have the possibility to display : First ID, Last ID, Count & Count (distinct) I dont' have the possibile to list all values so it looks like the picture I attached.

Could you support ?

[v-aatheeque]

Hi @randomuserista ,

Did @ibarrau response resolve your issue?

If yes, please consider marking the helpful reply as the accepted solution. This helps other community members with similar questions find answers more easily.

If you have any further questions, feel free to reach out.
Thank you for being a part of the Microsoft Fabric Community Forum!

[v-aatheeque]

Hi @randomuserista    

Did @ibarrau    response resolve your issue?If it did, we kindly ask you to mark the helpful reply as the accepted solution.

This will assist other community members with similar questions in finding answers more easily.

If you have any further questions or need additional assistance, please feel free to reach out.

Thank you for being a valued member of the Microsoft Fabric Community Forum!

[v-aatheeque]

Hi @randomuserista ,

Has the response from @ibarrau  resolved your issue?

If it did, please consider marking the helpful reply as the accepted solution—this helps other community members with similar questions find answers more easily.

Thank you for being a valued member of the Microsoft Fabric Community Forum!

[ibarrau · Accepted solution]

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,