Microsoft Power BI drillthrough from one table report to another (each uses different datasets)

[Anonymous]

I am fairly new to Power BI reporting. My question may be somewhat pedestrian. I have this situation below:

I have a Category report in a table in Page 1 of Power BI desktop; this Category report is developed
from Categories dataset.

I have a Product report in a table in Page 2 of Power BI desktop; this Product report is developed
from Products dataset.

The Category dataset and Product dataset have a M:1 relationship using CategoryID column, from the 
Products table to the Categories table (see diagram attached).

I set the drill through properties in  Page 2,  using the CategoryID column (see diagram).

However, when I go to Page 1, and right click a CategoryID value (say 1), I am not able to see the
Drillthrough option to navigate from Page 1 to Page 2 !

Am I wrong somewhere ? Even after watching many videos and reading many forums, I have been struggling with this for over a day. Please let me know.

[v-cherch-msft · Accepted solution]

Hi @Anonymous

You may try to use the CategoryID in Categories Table to set the drill through properties in Page 2. Then go to Page1, you'll see the Drillthrough option to navigate from Page 1 to Page 2.

Regards,

Cherie

[Anonymous]

Thanks v-cherch-msft.

It works now; am able to see the drill through option