Drillthrough automatically apply to visible slicer on page?

[Anonymous]

So I have a dashboard page that shows some graphs by quarter.

I also have a deatil page that shows item details and that page has a visible filter on the page for quarter.

I would like to setup a drillthrough button that when a user clicks on a particular quarter in one of the dashboard graphs, they can click the drillthrough button to be taken to the detail page. This works correctly, but the visible filter on the page will say "All" even though the user might have drilled through after selecting Q2. The data on the detail page is correctly filtered for Q2, but it's a little misleading when the visible slicer says all. Is there a way to have the visible slicer adjust based on the quarter chosen to drill-through?

[v-jayw-msft]

Hi @Anonymous ,

Not sure if i understand you correctly, but I believe the "ALL" on the detail page means all of the selected value?

Best Regards,

Jay

Community Support Team _ Jay Wang

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

[amitchandak]

@Anonymous , I far as I remember Drill through is visual at the page level filters. And Slicer is not Impacted. As suggested by @parry2k , you can use sync slicers

Check for any exiting idea or create the new one at :https://ideas.powerbi.com/forums/265200-power-bi-ideas/

[parry2k]

@Anonymous first of all not sure why you have slicer on drill through the page, since you are selecting slicer value on the main page and then slicer doesn't have any relevance on drill thru page.

but if you still want to display the slicer, you should use sync slicer between pages so that is always showing the same selection. 

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos 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.⚡