Power BI one diagram with two different lines with different dates but overlaped
So i have one Table with my data and a different date table with my dates. I connected them both with eachother.
"Zeitpunkt" is my date and time at which the "Wert" used energy.
I connected the tables via my "Datum" column.
This is my date table.
So my question is. What do i have to do if i 1. want to select my week number 2.get that week via date and time shown in my diagram and 3.have the next week calculated and overlaped with the other as shown in the picture after this.
As you can see. I can already select one week and get the next week displayed. I used DATEADD to get the data of the following week. My problem tho is, that it only shows the numbers of one hour of the day but i need all hours of the day 1-24. Thanks. If i explained something poorly then i am sorry. I am always open for further questions.