Line graph with date task completed compared to deadline date

[bb2530]

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

[ERD]

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: