Forum Discussion
Matrix : display all values
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 ?
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,
4 Replies
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,
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!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!
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!
