Joining lines in line graph

[cheskafausto]

Hi all, 

One of our users is requesting that the yellow MWACTUAL graph be "connected" to the  MWFORECAST , LL , UL graph so it looks like the yellow graph is splitting into 3 other graphs(please see figure for reference) . Is this possible to do that even though MWACTUAL, MWFORECAST, LL, and UL are all independet line graphs?

The granularity of the data presented is in 5 minutes. 

Expected output

[v-piga-msft]

Hi @cheskafausto,

I'm afraid we may not achieve your requirement directly in Power BI.

However, we may achieve that by creating the measures.

If it is convenitent, could share some data sample so that I could have a test.

Best  Regards,

Cherry

[cheskafausto]

I see. 

I cannot imagine how I would formulate the measures needed. Could you guide me with this? 

here is a sample data set

DATETIME,LL,MWFORECAST,UL,MWACTUAL
08/07/2018 11:00,,,,105
08/07/2018 11:05,,,,105
08/07/2018 11:10,,,,105
08/07/2018 11:15,,,,105
08/07/2018 11:20,,,,105
08/07/2018 11:25,,,,105
08/07/2018 11:30,,,,105
08/07/2018 11:35,,,,105
08/07/2018 11:40,,,,105
08/07/2018 11:45,,,,105
08/07/2018 11:50,,,,105
08/07/2018 11:55,,,,105
08/07/2018 12:00,166,178,189,
08/07/2018 12:05,142,149,156,
08/07/2018 12:10,121,124,127,
08/07/2018 12:15,121,124,127,
08/07/2018 12:20,130,134,139,
08/07/2018 12:25,164,175,186,
08/07/2018 12:30,170,182,194,
08/07/2018 12:35,166,178,189,
08/07/2018 12:40,167,178,189,
08/07/2018 12:45,156,165,174,
08/07/2018 12:50,143,150,157,
08/07/2018 12:55,155,164,173,