Problem filtering the dates for a table with two diferent dates

Hello everyone.

I'm having a problem with the date filters in the visuals, because I'm feeding the chart a table that contains for each value 2 columns with different dates.

Let me explain:

Table 1
Column A - File creation date

Column B - Date of orders

Column C - Number of orders

Table 2. Date
Only contains dates.

As I can't link table 2 [Dates] to the two date columns in table 1, the images are only filtering based on the active relationship.

For example, in these images, when I filter 2024 OR 2023, it's only working for THE date of the orders, which is the active relationship.

Can someone please help? Thank you.