Forum Discussion
Showing 2 Date Values on a Line Graph
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 , 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]))
4 Replies
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-trend/ba-p/882970
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,
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]))
