Graphique by date with filter

[Yuna-Evita]

Hello everyone, 

I have a sp list like :

Where Plan_Issue, Issue Title and Category are lookup column 

and i want to create graphic to integrete in my powerapps that's why I'm using power BI,

I need the graphic look like this :

So i want the sum of "open" and "closed" filter by type, category in my sp list, priority, until a date and from x last day. 

Can someone help me to di this ?

[amitchandak · Accepted solution]

@Yuna-Evita , You need to join both open and close date to one date table. On join will be inactive, that you will activate using userelationship

example

https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...

https://radacad.com/userelationship-or-role-playing-dimension-dealing-with-inactive-relationships-in...