Multiple date lines in two tables

Hello experts,

I kindly would like to request your help.

In my case I do have two tables with a date and these colums do have multiple lines with values by date. I have assigned a many to many relationship in both directions.

The target is to have a line chart by date which will present the sum per months (or quarter / or year) of both tables.

Table A (Column = Date / Column = QTY)

01/01/2023 = 10

03/01/2023 = 10

04/01/2023 = 10

Table B (Column = Date / Column = QTY)

02/01/2023 = 20

03/01/2023 = 20

05/01/2023 = 20

I would like to bring both tables now in a line chart, presenting the sum per month. Therefore I am adding the date of Table A, the QTY of Table A and QTY of Table B into the chart.

The outcome is Table A = 30 (Sum) and Table B = 20 (Sum). I assume the filter does only accept values with the Dates of Table A? 

My desired outcome would be to have the total sum of Table A in JAN and the total sum of Table B in JAN.

I have already tried to change the date format from dd/mm/yyyy to yyyy-mm, but it did not solve the issue.

Do you have any idea?

Thanks a lot!