How to compare Expected Release Date and Real/Projected Release Date of my courses on a line chart?

[Anonymous]

Hello!

I am fairly new to PowerBI and I have a task which I cannot seem to figure how to do. I also searched everywhere for this but it's either not possible or nobody made a topic about this?

Basically, I have a table with Module Titles (e.g. Module 1; Module 2 etc) and I have two columns, Expected Release Date (which is a date that was inputted before the project started) and Real/Computer Projected Release Date (which is a date after the project started and shows more accurately when the Module will be released). 

I want to plot these two columns in a Line Chart or similar visualisation to be able to compare the two and see which Modules are tracking below or above the Expected Release Date. Essentially I just need on one line to see the Expected Release Dates of all my modules and then on another Line to see the Real/Computer Projected Release Dates.

But everywhere online it seems like in order to be able to plot it like that you would need some values (e.g. I know you can plot Revenues across time and such). So I was wondering is there any potential solution to this?

Thanks in advance!

[Anonymous · Accepted solution]

Hi @Anonymous ,

Please follow these steps:

1.Create a measure, write it to a dax expression, and calculate the difference between the expected date and the real date.

Date Difference = DATEDIFF(MAX('Table'[Expected Release Date]), MAX('Table'[Real/Projected Release Date]), DAY)

2.The x-axis, y-axis, and tooltips are set as shown below.

3.The final result is shown in the figure below, with positive numbers indicating the number of days the real date is later than the expected date and negative numbers indicating the number of days the real date is earlier than the expected date.

If this result is different from what you expected, please provide the corresponding pbix file or screenshot to better help you solve the problem.

Best Regards,

Clara Gong

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.