Multi Currency Based by user selection with slicer?

[gpraveenonline]

Can this be possible to change the currency value (not symbol) based on the user selection?

For example:

Product  Price

   P1         10

   P2          20

User Choosing Currency1= Price * Exchange Rate (10.45) or if user choose Currency2 = Price * Exchange Rate (11.44)

Result set

Product  Price(Converted)

  P1           *****

  P2           *****

please help.

[ankitpatira · Accepted solution]

@gpraveenonline What you need to do is import currency lookuptable into power bi desktop which has currency code, conversion_rate columns. Then, create a slicer with currency code values and create a measure which looksup the conversion rate and multiplies with Price column of actual table based on user selection on slicer. You can use HASONEVALUE and FIRSTNONBLANK function to identify user selection and then perform lookup based on that for the conversion.

Hope that make sense.

[MrPowerBIPro]

@gpraveenonline

CurrencyType	Rate
Euro	40000
IRR	1
Dollar	35000

Default currency= IRR

CurrencyConversion = SWITCH(VALUES(Currency_Table[CurrencyType]),"Euro",[Euro],"Dollar",[Dollar],"IRR",1)

[ankitpatira · Accepted solution]

@gpraveenonline What you need to do is import currency lookuptable into power bi desktop which has currency code, conversion_rate columns. Then, create a slicer with currency code values and create a measure which looksup the conversion rate and multiplies with Price column of actual table based on user selection on slicer. You can use HASONEVALUE and FIRSTNONBLANK function to identify user selection and then perform lookup based on that for the conversion.

Hope that make sense.

[Aroth]

Hello, 

I have the same issue than gpraveenonline but his DAX formula in the reply doesn't work in my case. Could you please help me with the formula writing ? 

Thank you,

[gpraveenonline · Accepted solution]

selectedValue =
IF (
ISFILTERED ( 'calculations'[val] ) && HASONEVALUE ( 'calculations'[val] ),
LASTNONBLANK ( 'calculations'[val], 0 ),
MIN(products[price]) * MIN('calculations'[val])
)