Power Pivot - Currency Slicer

  • Hi,

    I have "Invoices" table with the values in one currency (GBP) and I have created another table "Currency".

    I was wondering if there is a way using Power Pivot to have a currency slicer, so that if USD or GBP is selected - it converts the "Amount" using the exchange rates in the "Currency" table?

    I have attached my sample data and thanks in advance :)