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 :)

    Files