Forum Discussion
Multi level drill-trough
Hello,
I'm building report where following Machine Number (page 1) I'm able to drill trough to different details pages. ( Machine details (page 2), Cost Details (page 3), Downtime Details (page 4) etc. )
I would like to have possibilty to navigate from details pages to another details page with settings from Main åpage. Meaning:
1 Page -> 2 page -> page 4 -> page 3 -> page 1
For now every time i would like to visit different details page I have to go back to page 1 and re-drill.
I will appriate every help !
Have you tried enabling keep all filters from the drillthrough options? You can see in the GIF below that the filter value from the main page is carried over to the final drillthrough page although its column is removed along the way
14 Replies
Hi LukCzar
Drillthrough requires that the originating page contains the drillthrough column. To drill through to another page without returning to the main page, this column must be added to the first drillthrough page, and the same process should be repeated for subsequent pages. You will need a similar setup as below
Hi LukCzar ,
Thanks for reaching out to the Microsoft fabric community forum.I would also take a moment to thank danextian , for actively participating in the community forum and for the solutions you’ve been sharing in the community forum. Your contributions make a real difference.
I hope the above details help you fix the issue. If you still have any questions or need more help, feel free to reach out. We’re always here to support you .
Best Regards,
Community Support TeamHi LukCzar ,
I hope the above details help you fix the issue. If you still have any questions or need more help, feel free to reach out. We’re always here to support you .
Best Regards,
Community Support Team
Thank you for your input !
Hm... I set Machine Number for drill-trough column on every page. But how to navigate between them to keep Machine number from 1st page ?Have you tried enabling keep all filters from the drillthrough options? You can see in the GIF below that the filter value from the main page is carried over to the final drillthrough page although its column is removed along the way
Hi LukCzar ,
This is related with the way you setup the drill trough.
I assume that you have a measure(s) or a column(s) that you use on the drill trough that specific measure or column is the value you use on the all the pages 1 to 4 so when you click the drill trough it will give you all the pages and you will then select the one you need.
To have this type of hierarchy drill trough you will need to setup the different pages with different columns or measures to be used in the drill trough so this woul be something similar to:
Initial Page Measures or column for drill Drill trough page Page 1 Value 1 Page 2 Page 2 Value 2 Page 3 Page 3 Value 3 Page 4 The Values 1 , 2 ,3 must be placed in the drill trough definition of the drill trough page and on the visual of the initial page so in this case you mus use Value 1 on the visual of page 1 you want to drill to page 2 and so forth.
Be aware that when you hit the back button that will always return you to the previous page you have been so if you go from page 1 to page 4 the back will return to page 1 and not page 3.
Hope this clarifies part of the problem if you want I can try and setup a similar page but can you let me know if you are making the drill trough based on columns or measures and if it is for all the visual on the page or only specific visual?
Hello, thak you for your respond !
Yes, I tried your sollution but I met minor hassle just after i applied DT button on details page - its innactive and I need to select something first to activate it.
Idea is to freelly navigate beetwen different details page of Machine.
P1 -> P2 -> P4 -> P3 etc. randomly. Popbably on every page button to P1 (back to the begininng) where I can deep dive to another Machine.
Hello,
I am not sure if I understand correctly,
because I don't understand if in page 2 there is a visualization that let you drill trought, anyway you can achieve this creating some buttons, and if you are in page 2, you can just move to whatever page you wantYeah, thats the case, I have visual which i want to drill trough only of 1st page.
What you want is possible, but not with drillthrough alone. Drillthrough only remembers the immediate source page. It can’t “chain” across multiple pages.
The standard pattern is:
1) Use drillthrough only from Page 1 → detail pages
Keep Machine Number as the drillthrough field on all detail pages.2) Add page navigation buttons between detail pages
On Page 2 / 3 / 4:
Add buttons that navigate to the other detail pages
Use Page navigation (not drillthrough)
3) Preserve the Machine context
Because all detail pages share the same drillthrough field (Machine Number), the filter context stays active when you navigate between them.4) Use the built-in “Back” button only to return to Page 1
So the flow becomes:
Page 1 → (drillthrough) → Page 2
Page 2 ↔ Page 3 ↔ Page 4 (page navigation, context preserved)
Back button → Page 1
Hej ! I really appreciate your answer !
I tried that solution, but unfortunatelly context is not saved for further pages. Only 1st Drill Trough keep machine number.
Hi LukCzar ,
Based on this description I believe that the best option is not a drill trough but do a sync of your slicers on each page and then add a page navigation panel, this would allow for you to go from page to page with the specific machine or machines selected without the need to select anything, except for the slicer with the machine selection.
