Forum Discussion
Drillthrough Filter
Hi, I have five pages which are A,B,C,D & E. The problem is when I already did some filter on page B. Then I go to page A and want to drillthrough into page B, the previous filter is not cleared and will cause drillthrough give some error. I need to clear all filter first on page B then I can use drillthrough to Page B.
How can we make without set a any reset button in pages, when we drillthrough from Pages A to Pages B, it will remain the new same filtered even before that we already did filtering in pages B.
Thank you.
Hi, i think the key setup is you may need to Sync all these slicers between PageA (main page) and PageB,C,D,E(DrillThrough pages), as this will avoid Slicer conflicts.
My prefered DrillThrough setup is i normally will hide those slicers on 'DrillThrough' pages.
For example for these slicers on DrillThrough page, after i synced them with slicers on MainPage i'll hide them so that it will give users a better layout on DrillThrough page.
5 Replies
Select the page then open the format tab.
Set the page type as drillthrough and turn off 'keep all filters'I hope this helps, please give a thumbs up and mark as solved if it does, thanks!
Hi, i think the key setup is you may need to Sync all these slicers between PageA (main page) and PageB,C,D,E(DrillThrough pages), as this will avoid Slicer conflicts.
My prefered DrillThrough setup is i normally will hide those slicers on 'DrillThrough' pages.
For example for these slicers on DrillThrough page, after i synced them with slicers on MainPage i'll hide them so that it will give users a better layout on DrillThrough page.
Hi aimanhafez130,
Thank you for reaching out to Microsoft Fabric Community.
Thank you MasonMA and wardy912 for the prompt response.
As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided by the user's resolved your issue? or let us know if you need any further assistance.
Thanks and regards,
Anjan Kumar ChippaHi @aimanhafez130,
Thank you for reaching out to Microsoft Fabric Community.
Thank you @MasonMA and @wardy912 for the prompt response.
As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided by the user's resolved your issue? or let us know if you need any further assistance.
Thanks
Hi @aimanhafez130,
Thank you for reaching out to Microsoft Fabric Community.
Thank you @MasonMA and @wardy912 for the prompt response.
As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided by the user's resolved your issue? or let us know if you need any further assistance.
Thanks
