Forum Discussion

cheskafausto's avatar
cheskafausto
Frequent Visitor
8 years ago

Joining lines in line graph

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

Need Help
Tutorial Requests

2 Replies

  • v-piga-msft's avatar
    v-piga-msft
    Icon for Resident Rockstar rankResident Rockstar
    8 years ago

    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's avatar
      cheskafausto
      Frequent Visitor
      8 years ago

      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,