Working with dual currencies format

[Chapin4u]

Hi, need help with the following:

The PBI report has a slicer of 2 currencies, US$ and Euro. Have a matrix visual with prices. 

What is needed is to display the prices formatted according to the currency selected.

Please advise how can I do this.

Thanks 

[Eric_Zhang · Accepted solution]

---

@Chapin4u wrote:

Hi, need help with the following:

The PBI report has a slicer of 2 currencies, US$ and Euro. Have a matrix visual with prices. 

What is needed is to display the prices formatted according to the currency selected.

Please advise how can I do this.

Thanks 

---

@Chapin4u

You could try to create a measure if you have a table like

price Measure =
SWITCH (
    ISFILTERED ( price[currency] ) && HASONEVALUE ( price[currency] ),
    LASTNONBLANK ( price[currency], "" ) = "Euro", FORMAT ( MAX ( price[price] ), "€##.00" ),
    LASTNONBLANK ( price[currency], "" ) = "US$", FORMAT ( MAX ( price[price] ), "$##.00" ),
    FORMAT ( MAX ( price[price] ), "$##.00" ) //if the slicer doesn't pick up any currency, use US$ by default
)

[Chapin4u]

Thanks for taking your time to show me the solution and the screen shots.

[Phil_Seamark]

Hi @Chapin4u

You can use the FORMAT function to create formatting to suit

eg,.

Currency US = FORMAT(100,"$##.00")

or

Currency EU = FORMAT(100,"€##.00")