Slicers change with drillthrough?

[PBIDevNoob]

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 drillthrough filter. Is there a way that the slicers will change along with the drillthrough filters?

[iainh]

I feel your pain on this, I have the exact same problem.

I have a Projects Overview page and a Projects Details page. I dont want the user to have to go back to the Project Overview to then go back into the next Projects Details page. So I added a Slicer filtered on the Project Number (unquie ID) which is the same data feild the drill through is based off.  However I ran into the same problem where the data on the Details was been filtered for by both Projects Numbers (same as your CAT & DUCK) example above. 

I assumed it would have built in logic that existing slicers filters and drill through filters based on the same data feild would be overridden upon a new filter selection used on the same data feild.

If you find a solution will you post it here please? (and visa versa)   

[parry2k]

One thing is not clear why there is a slicer on the drill thru page in the first place. if you really need a slicer on the drill thru page then watch this video on my YT channel https://youtu.be/frC3B_Dk3T8

✨ Follow us on LinkedIn and  to our YouTube channel

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make effort to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡ Visit us at https://perytus.com, your one-stop shop for Power BI-related projects/training/consultancy.

[PhillipWeeks]

I agree there should be a method to sync the same field slicer on a drill-through page with the actual field filter on the same page instead of having to click on the slicer and select the only option in the slicer dropdown as filtered through.

[parry2k]

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

[PBIDevNoob]

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: 

[v-yuta-msft]

@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.

[ccharras]

I have the same problem, it's very frustrating...
There seems to be a registered idea for this one already: https://ideas.powerbi.com/ideas/idea/?ideaid=69824fab-8b73-4009-aab7-cb80dc4bbf10

It would be worth voting more

[parry2k]

@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.