Relationship problems with Sharepoint and Excel

[Anonymous]

Hi,

Im new using relationships in power bi. I have a custom table X that gets it's data from excel. I made a drill through page that whenever I right click a ABC a new page opens up with data cards such as 

location

date

number

location is being pulled from table x

I have a sharepoint list that has the information of project ABC date and number. How do I link that information so that whenever I drillthrough project ABC location, date, and number fill in based on what's on the sharepoint list?

I tried making a relationship like linking project name in sharepoint list to project name in table X but every time I drill through date and number are blank.

[parry2k]

@Anonymous it is very hard to understand what the issue is? If possible share pbix file with sample date, remove any sensitive information before sharing.