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 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.