Having trouble to show my data correctly in a line chart. Forecast vs Actual.

[David4444]

Dear community,

I am trying to show Forecast vs Actual in 3 different linecharts, one is for year and month, one for days and one is for 15 min buckets. The problem I faced is when I select multiple days from my slicer in the the first and 2nd charts are good but the last one is summing my data and showing it in a single 12am-11:45pm interval instead of showing everyday with its on intervals accordingly.
1st screenshot : https://prnt.sc/nVbKY4yCMhlU
In the 1st screenshot there is year 2023 selected month july and then as days from 1st july-3rd july.
What I want to achieve is something like this in my last chart :
https://prnt.sc/QNvp3ootkx5a
For the data I have 2 tables :
FORECAST and ACTUALS they both have some id columns and name columns and then Interval1-Interval96 columns so basically the value is split in 96 intervals of 15 min (a day). I unpivoted the interval columns and now instead of having 96 columns I have 1 attribute columns which contains Interval1-Interval96 and Value column which contains their respective values. Both of the tables are have a relationship with a date table and  to another table I created in excel which is mapping every interval from 1 to 96 to have a 15 minute bucket from 00:00 to 23:45.

Does anyone have any idea how to solve this?

Thank you in advance, 
David

[Anonymous]

Hi @David4444 ,

Can you please share a pbix or some dummy data that keep the raw data structure with expected results? It should help us clarify your scenario and test to coding formula.

How to Get Your Question Answered Quickly  

Regards,

Xiaoxin Sheng

[MFelix]

Hi @David4444 ,

Since the information for the intervals get's repeated trough the days, what you are getting is the sum for that time frame for all the days you select, you need to make an hierarchy in the last chart using the day and the time frame.