Forum Discussion

PBIDevNoob's avatar
PBIDevNoob
Icon for Helper I rankHelper I
6 years ago

Slicers change with drillthrough?

I have a single select slicer on the drillthrough target--the slicer and the drillthrough filter is the same. Now, everytime I drillthrough to it, I need to change the slicer so that I get the right ...
Need Help
PBIDevNoob's avatar
PBIDevNoob
Icon for Helper I rankHelper I
6 years ago

Hi parry2k 

 

Please refer to the image below.

 

If my slicer default is Duck then I drillthrough with the value Cat, the slicer doesn't automatically change to Cat. So the page would be filtered to both Cat AND Duck, and my tables and charts would all return blank. To fix, I would have to change the slicert to Cat. 

 

I want to eliminate the process of having to change the slicer everytime I drillthrough to this page. I don't really want to create a duplicate page without the slicer, just so I can work around this. 

 

This is what happens: 

 

parry2k's avatar
parry2k
Icon for Super User rankSuper User
6 years ago

PBIDevNoob unfortunately it will not work, if you have selected default to duck, and you come to this page with cat, slicer still have value duck selected. it is a know functionality on how slicer works.