Showing 2 Date Values on a Line Graph

[stokidez]

Hi, hoping someone can help please. I'm trying to display a trend graph of the number of breaches which have occured over a period of time as well as the number which have been resolved on the same visual, both being displayed as two separate lines. When I add Date Resolved (GMT) to the Axis nothing happens to my graph - where am I going wrong please?

Thanks! 

[stokidez]

Thanks @amitchandak - thats worked! 😁

[amitchandak]

@stokidez , if you have 2 dates. You need to create a common date table join both dates with that. One join will be inactive. That you can activate in a measure using use relationship

refer my blog on that https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...

[stokidez]

@amitchandak thanks for your help!

I've created a date and linked to the two date fields (date resolved and date identified) as such:

If you can explain in a bit more detail how you would create the measure that would be great.

Thanks,

[amitchandak · Accepted solution]

@stokidez , Try USERELATIONSHIP like given below. Only needed for inactive relation

Resolved Date count = CALCULATE(COUNT(Employee[Employee Id ]),USERELATIONSHIP(Employee[Date Resolved],'Date'[Date]) )

Identified date count = CALCULATE(COUNT(Table[Title]),USERELATIONSHIP(Employee[Date Identified],'Date'[Date]))