Forum Discussion
Relationship between Power Bi tables not working dynamically
Hello,
I am working with 3 tables, They have a common column named "Customer ID". So I created many to many relationship (I only had this as a choice!) among these tables. But, when I started working in the Report view I couldn't see the graphs updating for the other table. Despite having a relationship amongst them.
I even created a bridge table, even that table had many to many relationship and also didn't update one table w.r.t other in the model view.
For example when I click on "Segmentation" slicer from one table the resultant from the other table i.e. Count of equipment sales appears to be blank (image attached)
Kindly help!
pbix file link attached Pbix File
Hello,
Thanks for the reply, I was able to solve the issue myself.
It had issue of Character Length, which I rectified and was finally able to connect the tables in 1 to Many.
4 Replies
Hi, my guess is that your bridge table contains duplicit IDs. That is why it requires M-N relationship.
My advice is to go to Power Query and remove duplicates in the ID columns of Bridge table. Next you fix your relations to 1-M.Thanks for your reply zenisekd , I already removed the duplicate rows, error and blank rows but still unable to solve it
Could you share the .pbix file with a sample (in a message)?
