Forum Discussion

nicksearle1966's avatar
nicksearle1966
Regular Visitor
6 years ago
Solved

Data issue between tables

Hi All I am so new to power-bi and have been following tutorials to create my first info graphic.  Whilst its raw and needs some work, its showing me pretty much what I am looking for.  However, the...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    6 years ago

    Well, Power BI creates those relationships automagically most of the time. You need to inspect your data model and the data. So, for example of how this could happen. Suppose you have an employee id and that is what Power BI decided to make the relationship on. Except that your data is bad and you have the same employee id for 3 different people in one of the tables. Well, there you go. So, I would start by looking at your data model and seeing what columns the relationship is built on. You just need to double-click the relationship or click on the relationship and see what columns get highlighted.

v-xicai's avatar
v-xicai
Community Support
6 years ago

Hi nicksearle1966 ,

 

For the relationship, recommend you create the star schema instead of circle schema, so you may delete the secondary relationships among these tables to break circle , and change the Cross filter direction of relationships from Single to Both , which will take these tables treated as a single table.

 

When you make some selections on one field of one table, then the other tables will return the corresponding result. You can learn more about relationship .

 

Best Regards,

Amy 

 

Community Support Team _ Amy

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.