Forum Discussion
Drill Through report Action
Hi,
I have dashboard which has details for the quantity where the created date less than 90 days or more than 90 in a dashboard and i need a new dashbaord as a detailed dashboard which is interactive with the main dashboard .
If i click on the number 928 it should navigate me to next dashboard and show info for sales . and if i click on 446 it should show me information for those categories . Detail dashboard should be like below :
DATA:
| Category | Sub Category | Sales | Quantity Q2 | country | Created date |
| Furniture | Chairs | 100 | 10 | China | 22/05/204 |
| Furniture | Tables | 100 | 20 | China | 23/05/2025 |
| Automobile | Cars | 100 | 30 | China | 21/01/2025 |
| Automobile | Bikes | 700 | 40 | China | 21/03/2025 |
| Furniture | Chairs | 100 | 13 | India | 21/01/2025 |
| Furniture | Tables | 500 | 22 | India | 21/02/2025 |
| Automobile | Cars | 100 | 54 | India | 21/01/2025 |
| Automobile | Bikes | 100 | 60 | India | 30/01/2025 |
| Furniture | Chairs | 100 | 30 | China | 22/01/2025 |
| Furniture | Tables | 300 | 29 | China | 23/05/2025 |
| Automobile | Cars | 200 | 88 | China | 21/03/2025 |
| Automobile | Bikes | 100 | 22 | China | 21/04/2025 |
| Furniture | Chairs | 500 | 21 | India | 12/1/2025 |
| Furniture | Tables | 100 | 33 | India | 12/1/2025 |
| Automobile | Cars | 600 | 54 | India | 21/01/2025 |
| Automobile | Bikes | 100 | 60 | India | 30/01/2025 |
| Furniture | Chairs | 100 | 30 | China | 22/01/2025 |
| Furniture | Tables | 100 | 29 | China | 23/05/2025 |
| Furniture | Sofa | 100 | 88 | China | 21/03/2025 |
| Furniture | Bed | 100 | 22 | China | 21/04/2025 |
| Furniture | Dining | 100 | 21 | India | 12/1/2025 |
| Furniture | Tables | 100 | 33 | India | 12/1/2025 |
| Furniture | Tables | 100 | 54 | India | 21/01/2025 |
| Furniture | Sofa | 100 | 60 | India | 30/01/2025 |
| Automobile | Cars | 1000 | 54 | India | 21/04/2025 |
| Automobile | Bikes | 100 | 60 | India | 30/06/2025 |
| Furniture | Chairs | 100 | 30 | China | 22/07/2025 |
| Furniture | Tables | 200 | 29 | China | 23/07/2025 |
| Furniture | Sofa | 100 | 88 | China | 21/03/2025 |
| Furniture | Bed | 100 | 22 | China | 21/04/2025 |
| Furniture | Dining | 100 | 21 | India | 12/1/2025 |
| Furniture | Tables | 400 | 33 | India | 12/11/2024 |
| Furniture | Tables | 800 | 54 | India | 12/10/2024 |
| Furniture | Sofa | 100 | 60 | India | 12/11/2024 |
Hi nish18_1990,
Has I refered in my previous post that option is not available on Power BI to drill trough using a single click option, you can have that option using navigation pane or bookmark navigation but for that you would need to do more complex formatting specially the bookmark as some complexity to work properly.
7 Replies
- grazitti_sapna
Super User
Hi nish18_1990
Enable Drill-Through on the Main Page- Right-click on the visual showing 928 or 446 (e.g., matrix or chart).
-
Now drag the INC Age Bucket field into the Drill-through filter section in the visualizations pane (bottom-right).
-
This enables drill-through based on this column.
I hope this solution helps you unlock your Power BI potential! If you found it helpful, click 'Mark as Solution' to guide others toward the answers they need.
Love the effort? Drop the kudos! Your appreciation fuels community spirit and innovation.
As a proud SuperUser and Microsoft Partner, we’re here to empower your data journey and the Power BI Community at large.
Curious to explore more? [Discover here].
Let’s keep building smarter solutions together!
-
- MFelix
Super User
Hi nish18_1990 ,
For this you need to create the new report page and in the options of the page you need to select the drill trough action, and use the quantity (the one used in the cards) has the drill trough field
Then you need to add the Quantity has a filter on the the matrix on the second page and this will enable the drill trough option on the cards.
You cannot have a click of a button directly on the card to activate the drill trough you can do it by overing over the card and wait a few seconds for the po-up card to appear and then select drill trough.
https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-drillthrough.
See file attach.
- nish18_1990
Helper III
When i click on the cards its not navigating to next page . If i click on any of the cards below it should filter those values and navigate to next page and show only those details based on card selection
- MFelix
Super User
Hi nish18_1990,
Has I refered in my previous post that option is not available on Power BI to drill trough using a single click option, you can have that option using navigation pane or bookmark navigation but for that you would need to do more complex formatting specially the bookmark as some complexity to work properly.