Need help to create a grouped bar chart over date

[La_Brocante]

Hi ! 

I'm discovering Power BI and can't find a way to translate my excel graph to Power BI. I have a table with this kind of values

Issue Number	Created on	Solved on	Topic
I240701	04/05/2024 12:56:10	17/06/2024 10:11:58	03H

This table contains hundreds of lines. I want to have a grouped bar chart, in which I could get the number of issues of a list of certain topic (like 03H and 07B), opened and solved each day. In x axis the dates, on y axis the number of tickets opened and solved, so that on each day I have two bars one for each measure. Plus, I still need to see the days where I have 0 opened and 0 solved.

I tried creating measures and using a DateTable but as I'm new I couldn't find a way to do it. 

Would love to hear if somebody could help me ! 

Thank you in advance !  

[La_Brocante]

I just checked and it doesn't work for my requirement. Fields Solved on and Created on are always filled because my extraction comes from all the issues solved. I just have different dates.

Issue Number	Created on	Solved on	Topic
I240701	04/05/2024 12:56:10	17/06/2024 10:11:58	03H
I240702	10/06/2024 16:24:03	17/06/2024 12:11:59	07V
I240702	10/06/2024 16:24:04	19/06/2024 13:11:55	07V
I240702	19/06/2024 15:24:03	19/06/2024 15:11:59	07V

For example here I need to have :

	Issues created	Issues solved
04/05	1	0
05/05... 9/06 (each line for each day)	0	0
10/06	2	0
11/06... 16/06 (each line for each day)	0	0
17/06	0	2
18/06	0	0
19/06	1	2

[VN999]

Create below measure and check it works for your requirement or not ?

IssuesOpened = COUNTROWS(FILTER('YourTable', NOT(ISBLANK('YourTable'[Created on]))))

IssuesSolved = COUNTROWS(FILTER('YourTable', NOT(ISBLANK('YourTable'[Solved on]))))

Replace with YourTable in above measure.