Forum Discussion
X Axis Challenge
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
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
1 Reply
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