cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
gpraveenonline Frequent Visitor
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           *****

 

please help.

Praveen Kumar G
Inatech
2 ACCEPTED SOLUTIONS

Accepted Solutions
Super User
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.

gpraveenonline Frequent Visitor
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
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.

gpraveenonline Frequent Visitor
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
Aroth Regular Visitor
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
MrPowerBIPro Regular Visitor
Regular Visitor

Re: Multi Currency Based by user selection with slicer?

@gpraveenonline

 

CurrencyTypeRate
Euro40000
IRR1
Dollar35000

 

Default currency= IRR

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

Enemy of can't
www.mrpowerbi.pro