Drllthrough data cards sharepoint data link data

Anonymous · ‎08-22-2019

HI,

I'm currently drilling through from this table to a 4th page with data cards. Every time I right click the project name it'll take me to the 4th page with all of the data cards filtered correctly excep 6 of them. Below is the table in which im drill through from. All of the data comes from sharepoint list A. The fields inside the red box come from sharepoint list B but I cant seem to get them to filter correctly based on the project I choose. For example, when I right click project 1 all of the other data cards gets filtered except those 6 because my data is not linked. I tried using relationships but it doesnt work. Can someone please help linking two datas?

Anonymous · ‎08-23-2019

HI @Anonymous ,

In my opinion,you can create bridge tables to link two sharepoint lists. After you create relationship between these visuals, these records will be mapping and filter based on their relationship.
In addition, you can also write a measure as filter based on drillthrough filter and compare with current visible row contents.

Applying a measure filter in Power BI

Regards,

Xiaoxin Sheng