Matrix only show first or last value

[portizparedes]

So we are building this matrix and it get filtered with a timeslicer so in the matrix when a certain date is pick it will show which event is on that date. But if I have two different events on the same day or week it only show one, because in the matrix value you have to pick if you want to show the first or the last and there is no "all" option. Any thoughs on how to fix this?

[v-chuncz-msft]

@portizparedes,

You may use a Table visual instead and select Don't summarize.

[portizparedes]

Thanks but I need to group the info in columns by month so the matrix was really useful. If there is no w ay to do it I will have to change to table but it will not be what I really wanted to present the info.

[v-chuncz-msft]

@portizparedes,

You could also create a measure.

Measure =
CONCATENATEX ( Table1, Table1[event], UNICHAR ( 10 ) )

[portizparedes]

Thanks I have no idea how to use measures but I will investigate.

Do you know if it will have to have a condition that concatenate only if the country and date are the same?

[v-chuncz-msft · Accepted solution]

@portizparedes,

A measure always operates on aggregations of data under the evaluation context. The context depends on user selections in the report or on the shape of the DAX query.