Forum Discussion
Relationship not working as expected
Hi, I have configured this many-to-one relationship in Power BI but it is not working as expected. Though the values are exactly the same, the relationship is not being recognized for the bin with ID 2. I have a similar issue doing the same thing with different tables. Any idea how I could resolve this?
Table one, the 'one' side of the many-to-one relationship.
Table two, the 'many' side of the many-to-one relationship. As you can see the values correspond.
This is a visual that illustrates the issue. As you can see, the bin with ID 2 has no values. All the values that should correspond with the bin with ID 2 are put in a category with no bin.
Thank you in advance.
2 Replies
- lbendlin
Super User
Please provide sanitized sample data that fully covers your issue. If you paste the data into a table in your post or use one of the file services it will be easier to work with. Avoid posting screenshots of your source data if possible.
Please show the expected outcome based on the sample data you provided. Screenshots of the expected outcome are ok.
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523 HI Anonymous,
It means your table records include not match keys so visuals show blank results.
Can you please share a pbix or some dummy data that keep raw data structure? It should help us clarify your scenario and test to trpueblshoot.
How to Get Your Question Answered Quickly
Regards,
Xiaoxin Sheng
