JIRA Created vs Resolved

[Anonymous]

Hello,

After multiple tests and many researches, I appeal to you.

I extracted JIRA data in excel format and use this data on power bi.
My last problem is to create a graph that compares tickets created and tickets solved like on JIRA.

I thought I understood that it was necessary to create a date table, link the 2 tables and use the elements of the date table to compare the 2 fields.

I consulted the few topics on this forum where some had the same problem as me but I don't know why, I'm the only one for whom it doesn't work, the following topics:

• https://community.powerbi.com/t5/Desktop/Trend-Created-Vs-Resolved/m-p/1667582
• https://community.powerbi.com/t5/Desktop/Jira-Dashboard-Created-vs-Resolved/m-p/1770615
• https://community.powerbi.com/t5/Desktop/Count-Weekly-Created-Resolved-tickets/m-p/806946

My last attempt is made in this direction:

• Creation of a date table
• Formatting created and resolved fields
  (Created1 = DATE(Day(..),MONTH(...),YEAR(...))
•  One-to-many link with the 2 previous fields with the date table (one active and one inactive)
• Axis: Date and values Created1 and Resolved1

Either the graph displayed nothing or it displayed a total with marked (empty) in the x axis

The expected result : 

The result obtained :

Bests Regards

[amitchandak]

@Anonymous , refer if the two attached files can help on a similar topic

or

https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-trend/ba-p/882970