Forum Discussion
Unable to create a relation between text fields
Hi Anonymous ,
1. You relationship netween the tables "Sales by Day" and "Stelling_Master_data" on column "StellinID" is perfectly right.
2. In you .pbix file on "Page1" tab, 3rd table on the right, you have moved Stellin Id from both the tables but you get blank data for StellinID from "Stelling_Master_data" against the StellinIDs coming from "Sales by Day". The reason for this is, these StellinIds don't exist in your "Stelling_Master_data".
Unique StellinId count in "Stelling_Master_data" = 136
Unique StellinId count in "Sales by Day" = 16
There exist no common "StellinIds" in these two tables.
If this helps and resolves the issue, appreciate a Kudos and mark it as a Solution! 🙂
Thanks,
Pragati
Hi Anonymous ,
Could you please show some screenshots of your data, data model, and relationship?
if you can share a pbix with some sample data, that will be better.
Thanks.
Aiolos Zhao
Yes I can share a file, but can you let me know how...I don't see the option
Or share your email address.
Thanks a lot for your help! This is really nice to have the ability to share knowledge like that!!
PY
- Pragati11
Super User
Hi Anonymous ,
You can upload the .pbix file on your drive and create a sharable link. That link can be shared here.
Thanks,
Pragati