cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
akhaliq7
Responsive Resident
Responsive Resident

In a drill through how to filter the slicer values in the drill through page

I have a table with 3 slicers in my first page, I want the slicer values to filter the values in the drill through page however even when I place the fields in the drill through page nothing happens I even turn off keep all filters. I think only those fields in the table filter through to the drill through page. However I do not want to add those slicer fields to my table for this to work. Is there another way to get my slicer fields to drill through into my drill through page. The drillthrough field I am using is in my table. I wanted the extra slicer fields to also filter through as well as they are date columns I want e.g. year field to filter with sales persons to my drill through page. Unless I do not add year to my table this may not work.

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@akhaliq7 , with keep all filter, in case you filter something on slicer it should pass to drill through the page. Hope visual is interacting with the slicer.

 

Also check adding those to drill though filter can help



Learn Power BI - Full Course with Dec-2022, with new DAX functions like Window, Index, Offset !!
Did I answer your question? Mark my post as a solution! Appreciate your Kudos !! Proud to be a Super User! !!
Formatted Profit and Loss Statement with empty lines

View solution in original post

1 REPLY 1
amitchandak
Super User
Super User

@akhaliq7 , with keep all filter, in case you filter something on slicer it should pass to drill through the page. Hope visual is interacting with the slicer.

 

Also check adding those to drill though filter can help



Learn Power BI - Full Course with Dec-2022, with new DAX functions like Window, Index, Offset !!
Did I answer your question? Mark my post as a solution! Appreciate your Kudos !! Proud to be a Super User! !!
Formatted Profit and Loss Statement with empty lines

Helpful resources

Announcements
Carousel_PBI_Wave1

2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

Power BI Summit Carousel 2

Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

Thank you 2022 Review

2022 Monthly Feature Releases

We had a great 2022 with a ton of feature releases to help you drive a data culture.