Date relationships with more than one table - some info missing

[russf99]

Relatively new to Power BI.  I am trying to create a new dashboard and it is not populating all the information.   To set the scene, I have a central date table with the usual fields (date, year, quarter etc), I have made this a date table.  I am trying to link this to two transaction tables (say called Finance and Operational).  the finance table only has a limited number of dates in it, and then the Operational table contains more transactions with a wider range of dates.

I have tried to link both transactional tables to the date table on the same Power BI page, but it only returns the dates that exist in both tables, ie. doesn't return results for dates in the Operational table but not in the finance table.  Both should be One ("date") to Many relationships, and I have tried a few different ways, but nothing seems to work.  In the below example there is only one row in the finance table (bottom) for 1 March 2023 but there are many more rows in the other project table in the middle.  I have added any filters / slicers for date as far as I am aware.  Thank you.

[v-kpoloju-msft]

Hi @russf99,

May i know has your issue been resolved? If the response provided by the Super user @Deku, addressed your query, could you please confirm? It helps us ensure that the solutions provided are effective and beneficial for everyone.

If yes, kindly accept the useful reply as a solution and give us Kudos. It would be appreciated.

Thank you for your understanding!

[v-kpoloju-msft]

Hi @russf99,

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.

Thank you.

[v-kpoloju-msft]

Hi @russf99,

I hope this information is helpful. Please let me know if you have any further questions or if you'd like to discuss this further. If this answers your question, please Accept it as a solution and give it a 'Kudos' so others can find it easily.

Thank you.

[danextian]

Ideally, relationships should flow in a single direction. Bi-directional relationships involving multiple tables can often create ambiguity when additional relationships are introduced, which prevents their creation.

[russf99]

Thank you.  That works!

[Deku · Accepted solution]

You need to turn off bi directional relationships on the date table