Showing Multiple columns in Matrix Table

[Krishnan_47]

Hi All,

I have loaded the following data as shown in the below table:

Countries	Type	1M	3M	Size	Currency
Singapore	Total Return	10	20	10000	SGD
Singapore	Excess Return	30	40
Malaysia	Total Return	50	60	20000	MYR
Malaysia	Excess Return	70	80

I need to display the loaded data as shown in the below screenshot:

I am able to bring Total Return and Excess Return columns using Matrix Visualizations, but I am not able to show Size and Currency exactly like the above table. Please do let know if this is possible.

[amitchandak]

@Krishnan_47 , First of all use fill down in power query

https://docs.microsoft.com/en-us/power-query/fill-values-column

And then matrix value add those on row and use stepped layout -off