Problems with four-table relationship

[nok]

Hello!

I'm having trouble doing something that I thought would be simple. I can't show the column and table names, but this is the model of the relationship of my tables:

I have two tables (blue table and yellow table) that I relate to a category table (red table), because in the blue table I have Category column and in the yellow table I have ID column. The red table is a reference table that relates all categories with their respective IDs, and therefore the blue table and yellow table relate to this table.

I want to create a line chart on my dashboard that will show the average of the values ​​of the blue and yellow tables by Category filter and Date filter.

So I created a Calendar table to relate the date column of the blue table and with the date column of the yellow table (just like I did with the red table), but whenever I go to relate the Calendar table to the second table, the relationship line becomes dotted (like in the image) and BI tells me that this relationship cannot be activated.

Is it not possible to create this type of relationship in Power BI? If not, how can I make this line chart that uses two different reference tables to filter the data from the blue table and yellow table?

[MattAllington]

Data is often not in the best formst for Power BI, but sometimes it can still work. I can't say if it will for you, or not. I would start by making those 2 many to many relationships filter single direction, red to blue/yellow and see if that helps. 

[MattAllington]

You say the red table is a category table.  This would appear to be a dimension table based on your description. So why do you have bidirectional many to many relationships between this table and the others?  If it is a dim table, it should have unique values for ID and Categories. 

[nok]

Hello, @MattAllington 
This can happen because the same ID can have more than one different category and a category can have more than one ID as well. The blue and yellow tables have rows that repeat several times.

So I wanted that, when filtering a specific category in the dashboard, the chat line shows a line for each ID that this category has.