Forum Discussion
Multi level drill-trough
- 9 months ago
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.