X Axis Challenge

[Anonymous]

Good Afternoon,

I have a dataset that includes various organizations, that each deal in various currencies. Furthermore, there are two different amount types for each currency; a direct amount, and a counter amount. 

I'd like to plot the currencies on the X-axis and the two amount types on the Y-axis. From there, I would like to drill down into the organizational level data i.e. depicting which organizations are making up how much of the EUR direct and counter amounts, for example. 

Here is an example dataset: 

Org.	Exposure Ccy	Direct	Functional Ccy	Counter
A	CAD	25	USD	-20
A	DKK	2	USD	-0.2
A	EUR	67	USD	-76
A	TRY	93	USD	-6
B	CAD	-4	USD	3
B	DKK	-5	USD	1
B	EUR	-16	USD	18
B	TRY	-0.5	USD	0
C	CAD	0	EUR	0
C	DKK	20	EUR	-3
C	TRY	-0.5	EUR	0
C	USD	-377	EUR	340
D	CAD	0	DKK	0
D	EUR	3	DKK	-24
D	TRY	128	DKK	-59
D	USD	1	DKK	-6

Here is an idea of where I am trying to go (Note: this chart is lacking the ability to drill down into the organizational level data):

I'm really looking forwar to your response.

Thank you very much!!

Jack

[Anonymous · Accepted solution]

Hi @Anonymous

What is the expected result?

Will you consider to create new table then create the visual like below?

Table 2 = 
var a = SELECTCOLUMNS('Table',"Org.",'Table'[Org.],"Ccy",'Table'[Exposure Ccy],"Amount",'Table'[Direct],"Ccy type","Exposure","Amount type","Direct")
var b = SELECTCOLUMNS('Table',"Org.",'Table'[Org.],"Ccy",'Table'[Functional Ccy],"Amount",'Table'[Counter],"Ccy type","Functional","Amount type","Counter")
Return
UNION(a,b)

Best Regards,

Jay