Forum Discussion
Line graph with date task completed compared to deadline date
I am looking to create a dashboard with a line chart like this one produced in Excel using this data - I cant get it to work?
From data like this:
Module Code | Exam Form 1 Completed | Exam Form 1 Deadline |
ABCD1234 | 04/10/2023 | 06/10/2023 |
ABCD1235 | 10/10/2023 | 06/10/2023 |
ABCD1236 | 20/10/2023 | 06/10/2023 |
ABCD1237 | 06/10/2023 | 06/10/2023 |
ABCD1238 | 06/10/2023 | 06/10/2023 |
1 Reply
Hi bb2530 , is your problem in the exact visual or in the measure? If we are talking about the visual, Power BI native visuals do not support dates on Y axis currently. So you either use the existing ones or look for a workaround..
To support the calculations, you need to have a Date table and 2 connections:
