Building Matrix With Multiple Currency Values

[Howdy2737]

Hello,

I am attempting to build a matrix with mutliple currencies being used as values (TRM, ACI, AVF) and placed in one table for each country as below. However, I wish the table to show the seperate values for each currency, but I am not sure how to select distinct currency values. In the table below, I have chosen TRM as the currency, so ACI and AVF are not correct. They should be 4852 (ACI) and 4852 (AVF). Is it possible to have multiple values in one PowerBi Matrix where the values are not seperate columns, but in the order as they are below? I have included the sample dataset below and thank you for the help ahead of time. 

TRM	ACI	AVF	Class AVF	Class ACI	ClassTRM	Country	Fiscal Quarter
1000	2048	2000	CoR	CoR	CoR	China	2024-1
1229	2058	2019	CoR	CoR	CoR	China	2024-2
1347	2189	2056	CoR	CoR	CoR	Japan	2024-1
2000	2943	2803	CoR	CoR	CoR	Japan	2024-2
2200	2010	2008	AVF	ACI	TRM	China	2024-1
3940	2842	2673	AVF	ACI	TRM	China	2024-2
2429	1938	1875	AVF	ACI	TRM	Japan	2024-1
3458	1983	1756	AVF	ACI	TRM	Japan	2024-2
4291	1877	1644	Revenue	Revenue	Revenue	China	2024-1
4458	1873	1737	Revenue	Revenue	Revenue	China	2024-2
2921	2891	2732	Revenue	Revenue	Revenue	Japan	2024-1
3329	3198	2984	Revenue	Revenue	Revenue	Japan	2024-2

[Dangar332 · Accepted solution]

hI, @Howdy2737 

follow step

1. in home tabe make transform data(go to power query editor)

2. in Transform tab select TRM, ACI, AVF column and click on unpivot column

3. in home tab click on close and apply

4. make new column for quarter as show in below and your data look like below image

Column = "qtr"&"-"&QUARTER('currency'[Fiscal Quarter])

5. in report view make matrix like below image