Multiple relationships "Date" table is not filtering correctly

[BYENER]

Hi All,

I have three tables each from a seperate process and all of them have a relationship with the WIP table (related column: serial number). I need the WIP table for additional information. Each process table has his own date. When I add a date filter from one of these tables in my report then it will not working, because I show information from all these tables in one overview. I need a separate date table, but the problem that I have is that I can only make one relation between two tables. How can make the relationships between these tables for a good working date? 

[amitchandak]

Most of your relationships are bi-directional. That is creating a problem.

Also, why most of your joins are Many to Many.

If possible please share a sample pbix file after removing sensitive information.Thanks.

My Recent Blog -

https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...

[BYENER]

Hi @amitchandak ,

I am a beginner and I don't have enough experience in relationships. Power BI makes the joins automatically many to many. What do you advise me to do? After trying this I can share a example .pbix.

Thanks in advance.

[amitchandak]

Please create the correct relationship. You can right-click and delete the relations which are not needed. Power BI by default creates the relation on matching name.

So first correct the data model. Please refer

https://docs.microsoft.com/en-us/power-bi/guidance/ 

To help you further with data model  I need pbix file. If possible please share a sample pbix file after removing sensitive information.Thanks.

My Recent Blog -

https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...

[BYENER]

I think that this topic is not needed anymore. I fixed the issue. Please close this topic.

[amitchandak]

You can only close it by marking a solution. You can share how you fixed it and mark that as a solution.