cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Microsoft
Microsoft

Working with dual currencies format

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 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Microsoft
Microsoft

Re: Working with dual currencies format


@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

Capture.PNG

 

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
)

Capture.PNGCapture.PNG

View solution in original post

3 REPLIES 3
Highlighted
Microsoft
Microsoft

Re: Working with dual currencies format

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

To learn more about DAX visit : aka.ms/practicalDAX

Proud to be a Datanaut!

Highlighted
Microsoft
Microsoft

Re: Working with dual currencies format


@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

Capture.PNG

 

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
)

Capture.PNGCapture.PNG

View solution in original post

Highlighted
Microsoft
Microsoft

Re: Working with dual currencies format

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

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Upcoming Events

Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Top Solution Authors
Top Kudoed Authors