title: Power BI: How to dynamically change currency
body: <p>We have requirement to allow user to choose which currency he wants to see in the dashboard, like below example:</p>
  
  <p><a href="https://i.stack.imgur.com/AnYPt.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/AnYPt.png" alt="enter image description here"></a></p>
  
  <p>By default, it's <code>GBP</code>, if user changes to <code>USD</code>, we need to show the spend by USD. Under the hood we already have table <code>InvoiceDetail</code> which contains columns doing currency conversion beforehand:</p>
  
  <pre><code>SpendInGBP
  SpendInUSD
  SpendInEUR
  </code></pre>
  
  <p>I am not sure how I can map when user chooses different currency using ChicletSlicer to different Columns.</p>