Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.
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
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,
User | Count |
---|---|
141 | |
113 | |
104 | |
78 | |
64 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |