Power BI one diagram with two different lines with different dates but overlaped

Steiner, Adrian 0 Reputation points
2024-01-15T12:12:22.29+00:00

So i have one Table with my data and a different date table with my dates. I connected them both with eachother. Forum

"Zeitpunkt" is my date and time at which the "Wert" used energy. I connected the tables via my "Datum" column. datetable

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. ErklärungErklärung

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.

Windows 10
Windows 10
A Microsoft operating system that runs on personal computers and tablets.
12,042 questions
0 comments No comments
{count} votes

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.