cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
JJoosse Frequent Visitor
Frequent Visitor

How to let filter/slicer respond to drillthrough actions?

Hi all,

 

For a Power BI report I am using both filters/slicers and a pie-chart with drillthrough capability. My question is this: is there a way to let the filters respond to the drillthrough actions so that the user knows which drillthrough actions he previously made?

 

I am using a pie-chart with 8 legend fields, so a user can perform 8 consecutive drillthrough clicks (and so it is easy to get lost). Therefore I want to have my filters/slicers at the top of the report also sync with the drillthrough clicks, so that for instance my customer filter will select this particular customer instead of showing 'All'. Is this possible, and if so how?

 

Any help is greatly appreciated!

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: How to let filter/slicer respond to drillthrough actions?

Hi @JJoosse ,

 

I recommend to use table visual to work around instead of slicer.

 

3.PNG

 

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

View solution in original post

3 REPLIES 3
Community Support Team
Community Support Team

Re: How to let filter/slicer respond to drillthrough actions?

Hi @JJoosse ,

 

One sample for your reference. We can add a slicer in the drillthourgh page, then we can achieve that. If it doesn't meet your requirement, kindly share your sample data and excepted result to me. Please upload your files to One Drive and share the link here.

1.PNG

 

2.PNG

Pbix as attached.

 

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
JJoosse Frequent Visitor
Frequent Visitor

Re: How to let filter/slicer respond to drillthrough actions?

Hi @v-frfei-msft,

 

Thanks for the reply and help. To clarify a bit more, I want my drillthrough and slicers to behave accordingly:

- When I click on the slicer and select for instance column 3 all the other graphs respond to that, showing only values for column 3.

- What I want is to have this work the other way around as well: so that when I click on one of the parts of the pie-chart, the corresponding checkbox in the slicer gets selected as well and it looks like this:

 image.pngimage.png

Community Support Team
Community Support Team

Re: How to let filter/slicer respond to drillthrough actions?

Hi @JJoosse ,

 

I recommend to use table visual to work around instead of slicer.

 

3.PNG

 

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

View solution in original post

Helpful resources

Announcements
Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Solution Badges

New Solution Badges

Two waves of brand new solution badges are coming! Read the article for more information on our new community badges.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Users Online
Currently online: 60 members 958 guests
Please welcome our newest community members: