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 Completio...
Need Help
Tutorial Requests
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] )
)