Forum Discussion
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.
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.
selectedValue =
IF (
ISFILTERED ( 'calculations'[val] ) && HASONEVALUE ( 'calculations'[val] ),
LASTNONBLANK ( 'calculations'[val], 0 ),
MIN(products[price]) * MIN('calculations'[val])
)
4 Replies
- ankitpatira
Community Champion
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.
selectedValue =
IF (
ISFILTERED ( 'calculations'[val] ) && HASONEVALUE ( 'calculations'[val] ),
LASTNONBLANK ( 'calculations'[val], 0 ),
MIN(products[price]) * MIN('calculations'[val])
)
ArothAdvocate II
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,
- MrPowerBIPro
CurrencyType Rate Euro 40000 IRR 1 Dollar 35000 Default currency= IRR
CurrencyConversion = SWITCH(VALUES(Currency_Table[CurrencyType]),"Euro",[Euro],"Dollar",[Dollar],"IRR",1)
