Forum Discussion
Slicer Selection for currency conversion
Hello Community,
I have a VIEW containing sales column and all the values are in euros. I have factcurrency table which contains multiple currencies with everydays rate.
I want to create a slicer for the multiple currencies where I can chose a currency, which I want either in euros, usd or any given currency in the table.
CurrencyRate Table
| TimeID | ExchangeRate | CurrencyCode | CurrencyName |
Tried few methods but didn't get desired results.
Any tips?
The Sample Data is given below as two tables: ExchangeRate and FactSales. The idea is to create a slicer where I want to see sales amount in any currency by selecting currencycode in slicer.
ExchangeRate TimeID EuroRate CurrencyCode 20120101 1 EUR 20120102 1 EUR 20120103 1 EUR 20120101 1,02 USD 20120101 89,1 INR 20120101 1,54 SGD 20120101 0,605 LVL 20120102 0,602 LVL 20120103 0,59 LVL FactSales ID InvoiceDate Amount in EUR 20120101 2012-02-01 1525 20120102 2012-02-02 1200 20120103 2012-02-03 112 20120101 2012-02-01 520 20120101 2012-02-01 4200 20120101 2012-02-01 510 20120101 2012-02-01 2300 20120102 2012-02-02 1523 20120103 2012-02-03 1740
2 Replies
v-cherch-msftMicrosoft Employee
Hi Anonymous
You may check below similar post.If you need further help,please share some sample data.
Regards,
Cherie
The Sample Data is given below as two tables: ExchangeRate and FactSales. The idea is to create a slicer where I want to see sales amount in any currency by selecting currencycode in slicer.
ExchangeRate TimeID EuroRate CurrencyCode 20120101 1 EUR 20120102 1 EUR 20120103 1 EUR 20120101 1,02 USD 20120101 89,1 INR 20120101 1,54 SGD 20120101 0,605 LVL 20120102 0,602 LVL 20120103 0,59 LVL FactSales ID InvoiceDate Amount in EUR 20120101 2012-02-01 1525 20120102 2012-02-02 1200 20120103 2012-02-03 112 20120101 2012-02-01 520 20120101 2012-02-01 4200 20120101 2012-02-01 510 20120101 2012-02-01 2300 20120102 2012-02-02 1523 20120103 2012-02-03 1740