Metrics in different currency in Power BI

[akj2784]

Hi,

I have a metric such as Revenue. If I select USD from the slicer, my data should show the symbol of $.

If I select Billing Currency, then I would like to show the data along with Billing Currency symbol which could be any currency.

Is there any way to show it dynamically ?

Regards,

Akash

[v-yuta-msft · Accepted solution]

Hi akj2784,

Slicer can't filter Column so creating two columns like [USD] and [Billing Currency] can't work. As a workaround, you can create your table with pattern below:

 

Regards,

Jimmy Tao