Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
cristianml
Post Prodigy
Post Prodigy

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
Super User

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
Super User

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

hI @jdbuchanan71 

 

It works perfect !! Thanks!

 

perfect.jpg

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.