Forum Discussion
Drill through does not appear and does not work
So I am encountering a wierd problem here with drill through. page 1-3 are displaying table 1-3 respectively. Page 3 has drill through column pointing to unzip_file_name column of table 2 in page 2 and it works. Then in page 2 I set drill through column to table 1 zip_file_name column which has the table in display in page1. However, I cannot find any drill through option when I right click the zip_file_name rows in page1 and even if I add a drill through button it cannot show page2 as destination but only page3. I tried both and single relationships between the zip_file_names in table 1 and table 2 but falied in vain. I sync the slicer between page 1 and 2 and remove all the slicers but all in vain.
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.
10 Replies
rohit1991Super User
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.
- 123abc
Community Champion
Hi
If possible can you please share your sample file of pbix.
- ajaybabuinturi
Hi Dragut<,
I wanted to let you know that Power BI only shows a drill-through target if the exact column used on the source visual is also added to the Drill through >> Add drill-through fields pane on the target page. This must be the SAME column instance from the SAME table, not a related column or a column with the same values.
This is why your drill-through from Page 3 works (using unzip_file_name from Table 2) but Page 1 --> 2 does not work even though the column names look similar.Try with below step
On Page 2 (your drill-through target), drag Table 1[zip_file_name] into the drill-through pane and On Page 1 (your source table visual) The visual must display that same exact field Table 1[zip_file_name].Thanks,
If you found this solution helpful, please consider giving it a Like👍 and marking it as Accepted Solution✔. This helps improve visibility for others who may be encountering/facing same questions/issues.
