How to create a switch or slicer to switch between local/home currency

[Anonymous]

Hello wonderful PBI community,

I do competitor intelligence, where I need to display a table visual and timeseries graph to display prices movements, and aggregated min/max/avg prices, for competitors in nearby countries. The data comes from a long SQL table, with SKU#, Store, Date and sales_price(local currency).

I would like to be able to make a switch/slicer so I can switch between showing the currency in the local currency or convert it my home currency.  My first attempt so far has been to make a table with the conversion rates, where my thoughprocess was to make a measure where sales price would be calculated as: 

sales_price = sales_price * currency_conversion_rate( or) 1), where a button or a slicer should make me able to switch between the local currency (multiplying with the conversion rate) or just simply multiplying with 1 to show it as local currency.

I have been looking through some threads such as https://www.sqlbi.com/articles/currency-conversion-in-power-bi-reports/ and others, which for me seems a little complicated and for another use case. 

My very simple diagram looks like this, with nord_prices consitging of some 32 million rows, so I do not find it very appropiate to go the Power Query way and add a calculated column to nord_prices.

The display for visualizing it looks like this, where the stores can be from different countries:

'

I hope very much you can help me find a solution!

Best regards,

Simon 

[lbendlin]

Does your exchange rate table have monthly entries for each currency?

Please provide sanitized sample data that fully covers your issue. I can only help you with meaningful sample data.
Please paste the data into a table in your post or use one of the file services like OneDrive or Google Drive.
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...

Please show the expected outcome based on the sample data you provided. Screenshots of the expected outcome are ok.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523