Drill through does not appear and does not work

[Dragut]

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. 

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

[Dragut]

In page 2 I already use Table 1[zip_file_name] in the drill-through pane.

[danextian]

Have you checked whether you're using the same column both in originating and drillthrough pages?

[v-menakakota]

Hi @Dragut ,

Thanks for reaching out to the Microsoft fabric community forum. 

I would also take a moment to thank  @danextian  and @rohit1991    , for actively participating in the community forum and for the solutions you’ve been sharing in the community forum. Your contributions make a real difference.

Have you checked whether you're using the same column ?

Best Regards, 
Community Support Team

[Dragut · Accepted solution]

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.

[v-menakakota]

Hi @Dragut ,

Thank you for the update.

Please continue to use community support team.

Best Regards, 
Community Support Team

[ajaybabuinturi]

Could you please provide the sample data of .pbix file

[rohit1991]

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 :

[Dragut]

No, my drill through pane in page2 is pointing at zip_file_name in table1 which is in display in page1.

[123abc]

Hi

If possible can you please share your sample file of pbix.