drillthrouth option not showing on right click

[MarkDenHeijer]

Hi 

I have a data model with 2 tables (see image). There is a relation from Projects (idProject) to Items (ProjectID). Relation is active, and set to filter in both directions. (also tried 1 direction, makes no difference). 

On the first page I have a table with Projects: ProjectName. My second page has the items. ProjectID has been added as a drill through field, and the cross report setting in the second page has been turned on. I Whatever I do, the drilldown option doesn't show up in my right click menu. When I move the table on the first page to the second page, the filtering works fine, meaning the datamodel seems to  be ok. 

I have already tried everything in the following topic, but still it doesn't help. 

https://community.powerbi.com/t5/Desktop/Drillthrough-option-in-right-click-dropdown-on-main-page-vi...

[v-shex-msft]

Hi @MarkDenHeijer,

What type of drill though you mean? drill through the report pages or drill through the reports?
Drill through report pages requires setting 'drill through filter' fields on target page, then you can use visual on other report pages (visual contains drill thought filter filed) to drill through to specific target page with filter.

For drill through cross reports, please refer to official tutorial video:

Regards,

Xiaoxin Sheng