cancel
Showing results for
Did you mean:
Frequent Visitor

## Multi Currency Based by user selection with slicer?

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           *****

Praveen Kumar G
Inatech
2 ACCEPTED SOLUTIONS

Accepted Solutions
Super User

## Re: Multi Currency Based by user selection with slicer?

@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.

Frequent Visitor

## Re: Multi Currency Based by user selection with slicer?

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

Praveen Kumar G
Inatech
4 REPLIES 4
Super User

## Re: Multi Currency Based by user selection with slicer?

@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.

Frequent Visitor

## Re: Multi Currency Based by user selection with slicer?

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

Praveen Kumar G
Inatech
Regular Visitor

## Re: Multi Currency Based by user selection with slicer?

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,

Highlighted
Regular Visitor

## Re: Multi Currency Based by user selection with slicer?

@gpraveenonline

 CurrencyType Rate Euro 40000 IRR 1 Dollar 35000

Default currency= IRR

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

Enemy of can't
www.mrpowerbi.pro