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
cheskafausto
Frequent Visitor

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 outputExpected output

2 REPLIES 2
v-piga-msft
Resident Rockstar
Resident Rockstar

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

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

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,

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.