How to Make a Double Line Graph with two date columns?

[rohithsundar]

Hello,

I am running into issues creating a double line graph (line graph with 2 lines). I am trying to have the x-axis as months January - December. I have a column that shows an "Expected Completion Date" and another column that shows "Actual Completed Date" and want to show both lines on the same graph. Right now, it is showing as the same line. Thanks! 

[peegee68]

Thanks for this.

It helped me out on a a table where I had Action Items table with Created, Closed, and Due Dates all in the same row.  Was having all sort of problems with accurately plotting these values until I found your example above.

Paul

[Ashish_Mathur]

Hi,

Share the download link of the PBI file and the MS Excel file (which you would have imported in the PBI file).

[Jihwan_Kim]

Hi,

I am not sure how your data model looks like, but I suggest having a calendar-dimension table with one active relationship and one inactive relationship, like the below picture. And then try using USERELATIONSHIP DAX function when analyzing inactive relationship.

I tried to create a sample pbix file like below.

I hope the below can provide some ideas on how to create a solution for your data model.

Project count actual complete date: = 
COUNTROWS(Project)

Project count expected complete date: =
CALCULATE (
    COUNTROWS ( Project ),
    USERELATIONSHIP ( 'Calendar'[Date], Project[Expected complete date] )
)