Forum Discussion

PBIDevNoob's avatar
PBIDevNoob
Helper 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
parry2k's avatar
parry2k
Super User
6 years ago

PBIDevNoob not sure if I understood your question, could you provide some example.

PBIDevNoob's avatar
PBIDevNoob
Helper 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
    Super 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.

  • v-yuta-msft's avatar
    v-yuta-msft
    Community Support
    6 years ago

    PBIDevNoob ,

     

    I'm afraid power bi doesn't have this feature. You need to create a new page and remove the slicers or unclick the seleted values manually. Actually you can submit your idea here to help power bi improve.

     

    Community Support Team _ Jimmy Tao

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.