Forum Discussion
CoryMBush
6 years agoFrequent Visitor
Need Help, How do stop drillthrough from picking up my sync'd date slicers
Hi, I am using drillthrough buttons and a table to go from my overview page to several different detail pages. All of the pages have the same Date slicer synced. I want to be able to drill through...
v-kelly-msft
6 years agoCommunity Support
Hi CoryMBush ,
As the date column is related to the data which is drillthroughed and drillthrough will pass all the filters.I don't think that you can remove some of the filters when using a drillthrough.
However, a workaround could be that on the drillthrough landing page, you can put the date in "Filters on all pages"pane, in which you could select 'ALL' of the date column to lock all the dates.
So it will be like, all the filters go through and then using the filter pane, having the selection selected to all, you are removing the inquired filters.And there,you can make a second filter with dates after drillthrough.
before drillthroughafter drillthrough
Here is a sample .pbix file you could refer to.
Best Regards,
Kelly
Kelly
Did I answer your question? Mark my post as a solution!