Forum Discussion
Helper IIIDrill Through as per the selection
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, in your message, does "navigate me to next dashboard" mean 'next page' or a different dashboard?
If this means 'Navigating you to next page', Drillthrough page is an option. Using blank button plus bookmark is also a good option.
You may refer to my demo file in the attached 'Button+Bookmark'.
Key setup, place the button over your KPI card and Sync the filters on both pages.
6 Replies
- FBergamaschi
Super User
You need to setup a drill through page in which you have the dashoard details you showed
here the details
https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-drillthrough
If this helped, please consider giving kudos and mark as a solution
me in replies or I'll lose your thread
consider voting this Power BI idea
Francesco Bergamaschi
MBA, M.Eng, M.Econ, Professor of BI
- MasonMA
Hi, in your message, does "navigate me to next dashboard" mean 'next page' or a different dashboard?
If this means 'Navigating you to next page', Drillthrough page is an option. Using blank button plus bookmark is also a good option.
You may refer to my demo file in the attached 'Button+Bookmark'.
Key setup, place the button over your KPI card and Sync the filters on both pages.
nish18_1990Please attach the file for reference .
- MasonMA
There's a link in my message:)
v-karpurapudCommunity Support
Hi nish18_1990
We are following up to see if you have had the chance to review the information provided. If you have any further questions, please do not hesitate to contact us. Could you confirm whether your query has been resolved by the solution provided by FBergamaschi and MasonMA ? If so, kindly mark the helpful response and accept it as the solution to assist other community members in resolving similar issues more efficiently. If not, please provide detailed information so we can better assist you.
Thank You!- v-karpurapud
Hi nish18_1990
I wanted to check if you’ve had a chance to review the information provided. If you have any further questions, please let us know. Has your issue been resolved? If not, please share more details so we can assist you further.
Thank You.
