cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
cristianml
Post Patron
Post Patron

Various values in line chart (Fx Rate)

Hi,

I need to show various Measures in a line chart. in this case is depending of the "Location".  Any ideas / measure that could help ?

I think "Var" & "return" could work but not sure how to built that measure.

 

FX RATE.png

Thanks & regards

1 ACCEPTED SOLUTION
jdbuchanan71
Super User II
Super User II

Hello @cristianml 

I think something like this is what you are looking for.  I don't know where your list of locations is (what table) or what countries you want to use EUR for but this should get you started.

 

Display Amount =
VAR _Location =
    SELECTEDVALUE ( Locations[Location] )
RETURN
    SWITCH (
        TRUE (),
        _Location = "Argentina", [FX Rate ARS],
        _Location = "China", [FX Rate CNY],
        _Location
            IN {
            "AUSTRIA",
            "BELGIUM",
            "FINLAND",
            "FRANCE",
            "GERMANY",
            "GREECE",
            "ITALY",
            "LATVIA",
            "SPAIN"
            }, [FX Rate EUR],
        _Location = "India", [FX Rate INR],
        _Location = "Poland", [FX Rate PLN]
    )

View solution in original post

2 REPLIES 2
jdbuchanan71
Super User II
Super User II

Hello @cristianml 

I think something like this is what you are looking for.  I don't know where your list of locations is (what table) or what countries you want to use EUR for but this should get you started.

 

Display Amount =
VAR _Location =
    SELECTEDVALUE ( Locations[Location] )
RETURN
    SWITCH (
        TRUE (),
        _Location = "Argentina", [FX Rate ARS],
        _Location = "China", [FX Rate CNY],
        _Location
            IN {
            "AUSTRIA",
            "BELGIUM",
            "FINLAND",
            "FRANCE",
            "GERMANY",
            "GREECE",
            "ITALY",
            "LATVIA",
            "SPAIN"
            }, [FX Rate EUR],
        _Location = "India", [FX Rate INR],
        _Location = "Poland", [FX Rate PLN]
    )

View solution in original post

hI @jdbuchanan71 

 

It works perfect !! Thanks!

 

perfect.jpg

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Get Ready for Power BI Dev Camp

Power BI Dev Camp - June 24th

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

Top Solution Authors
Top Kudoed Authors