Bidirectional relationship

Hi all,

I have two tables with a many to one (*:1) relationship.

Table 1: main data table

table 2: Dates table (Many)

Creating a single directional relationhip means I can't filter data from the main using slicers with data from the Visit Dates

Creating a both directional relationship allows me to filter by the visit dates table however, it is omitting data.

How can I resolve this?

Any help would be much appreciated.

Thanks in advance