Forum Discussion
Showing Multiple columns in Matrix Table
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.
1 Reply
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
