CODEWITHSUNDEEP
matrixpowerbireport
morg
morg

Reputation: 1191

PowerBI matrix listing all values

I would like to create a visual priority matrix in Power BI, the minimum I would like to do is this :enter image description here

So I put "Business Value" in Row; "Complexity" in Columns and the "ID" in Values. However I obtain this :

enter image description here

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 ?

Upvotes: 1

Views: 31

Answers (1)

davidebacci
davidebacci

Reputation: 30304

Create a measure and use that in the values. Something like:

CONCATENATEX(yourTable,yourcolumn, ",")

or

CONCATENATEX(yourTable,yourcolumn, UNICHAR(10))

Upvotes: 0

Related Questions