Powerbi model with two table

Hello

I have two tables with several colums and some of those have the same value; for example both have the colum Color and the colum Date (one is sales date the other accounting date); in the first table I can have {(Blue, 30.09.2022, 20),(Red, 31.10.2022, 10)} and on the other {(Blue, 30.09.2022, $5),(Blue, 31.10.2022, $15),(Red, 31.10.2022, $10)}.

I would like to relate this two tables so that when a filter in a chart one the other will be filter too.

I've tried to creat a date table and use this and also a table with {Blue, Red} that would be the "master" for the color, but in the end or the color relation is active or the date and I need both.

Many thanks,

AC