datasetrelationshippowerbidrilldowndrillthrough

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

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.

enter image description here

enter image description here

enter image description here

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

enter image description here

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

enter image description here

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 !

enter image description here

enter image description here

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.

Solution

  • I did the following:

    In the Page 2 (Products detail report), I changed the drill-through filter from CategoryID (Products table) (this was set originally) to CategoryID (Categories table).

    Now, when I open Page 1 (Categories summary report), and right click the CategoryID, I am able to see the drill-through option. It takes me to Page 2 Products detail report, only with the filtered Categories.

    It was a matter of changing the table (for the same column - CategoryID).

    Thanks for the solution