Forum Discussion
Drill through does not appear and does not work
- 9 months ago
I have the final workaround to delete unworking page2 and replicate page3 and it solves the matter. Looks like there are some underlying meta data in page2 that prevents the linking, unfortunately.
Hii Dragut
Drill-through only appears when the exact field you used in the drill-through setup (same column, same table, same data type) is present in the source visual’s data context. In your case, Page 1 is showing zip_file_name from Table 1, but your drill-through page is expecting zip_file_name from Table 2. Even if both columns contain the same values, Power BI treats them as different fields, so the drill-through option remains hidden or greyed out.
To fix this, make sure the same physical field is used in both places either drag zip_file_name from the same table into Page 1 visuals OR create a dimension table for zip_file_name and use that field consistently. Once the drill-through page receives the correct field context, the right-click drill-through option will immediately appear.
Example as below :
No, my drill through pane in page2 is pointing at zip_file_name in table1 which is in display in page1.