column based on slicer value

[vimala]

Productl1	ProductL2	USDccyAmnt	EURccyAmnt	MultiCCyAmnt	Multiccy
ABC	sss	20	25	20	AUD
ABC	ccc	40	45	30	CAD
EFG	sss	20	25	5	JPY
EFG	bbb	40	45	40	USD
EFG	aaa	40	45	45	EUR
Slicer
USD
EUR
MultiCcy
If usd  selected , then I have to use USDccyAmt to do further calculations
IF EUR Selected , Then I have to use EURccyAmt to do further calclations
If Multiccy selected then then I have to use MulticcyAmnt to do further calculations
Simeltaneously have to pupulate the CCY coulmn , in addition to measures to show the ccy break up when Multiccy s selected.
based on the above all my visuals should change?
have bar chart,pi chart,crosstab etc.
I am stuck when multi ccy is selected, how to pupulate the ccy column and corresponding mesures to show in visuals ,cross tab table as well.
if anyone knows how to do it please let me know

[v-yuta-msft · Accepted solution]

@vimala ,

The slicer chart doesn't have this feature, but there's a workaround, click query editor-> click on colunm [USDccyAmnt], [EURccyAmnt] and [MulticcyAmnt]-> click transform-> Unpivot Columns.

 

Then create a conditional column in power query like below:

 

After apply&close, build a relationship between the two tables and the result is like below:

 

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.