Forum Discussion

rohithsundar's avatar
rohithsundar
New Member
3 years ago

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

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! 

 

 

Need Help
Tutorial Requests

3 Replies

  • Jihwan_Kim's avatar
    Jihwan_Kim
    Super User
    3 years ago

    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] )
)

     

     

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    3 years ago

    Hi,

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

  • peegee68's avatar
    peegee68
    Frequent Visitor
    2 years ago

    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