Matrix table couldn't display values

Hello Bobby21,

The Matrix visual is used to show a measure aggregated over some grouping. The grouping can happen in 2 dimensions, Rows and Columns.

Since you measure is a Text, the options for aggregation function are First, Last and Count.

To fix your issue and show exactly as you have on the the spread sheet you have, you need to add another level of grouping that would be unique per row. Something like an Order number.

Then add the Order # to the Row hierarchy.

Ramy

Anonymous

You can fill down the null countries in Query Editor as RamySaroufim said. And then use the Table visual to show the result as below.

Best Regards,
Herbert