Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to 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
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
Thanks v-cherch-msft.
It works now; am able to see the drill through option
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
97 | |
85 | |
67 | |
59 |
User | Count |
---|---|
150 | |
120 | |
100 | |
87 | |
68 |