cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Yael Member
Member

Drill through - Slicers and Visual Filters

Hello,

 

From what I can see, the drill through capability doesn't take into consideration the value of the visual level filter, nor the value chosen in a page slicer - Is that correct?

 

Thank you

1 ACCEPTED SOLUTION

Accepted Solutions
Moderator v-sihou-msft
Moderator

Re: Drill through - Slicers and Visual Filters

@Yael

 

The slicer is only working in current page. It can't cross pages.

 

Regards,

View solution in original post

8 REPLIES 8
Moderator v-sihou-msft
Moderator

Re: Drill through - Slicers and Visual Filters

@Yael

 

The drill through will take the Page/Visual Level filter selection to slice the data. Please verfiy the built relationship between the fields in filter and visual. 

 

33.PNG

 

34.PNG

 

Regards,

Yael Member
Member

Re: Drill through - Slicers and Visual Filters

@v-sihou-msft - but can the drill through recieve parameters from the slicer?

Thank you!

Moderator v-sihou-msft
Moderator

Re: Drill through - Slicers and Visual Filters

@Yael

 

Sure, it will take the selection from slicer. 

 

55.PNG

 

66.PNG

 

 

Yael Member
Member

Re: Drill through - Slicers and Visual Filters

@v-sihou-msft 

 if the detailed report is in another page, then from what I see it doesn't receive parameters from the slicer in the first page.

Moderator v-sihou-msft
Moderator

Re: Drill through - Slicers and Visual Filters

@Yael

 

The slicer is only working in current page. It can't cross pages.

 

Regards,

View solution in original post

Yael Member
Member

Re: Drill through - Slicers and Visual Filters

@v-sihou-msft thank you

kevkilner Frequent Visitor
Frequent Visitor

Re: Drill through - Slicers and Visual Filters

You can "cheat" by copying the Slicer to the drill through page and then sync'ing them when prompted. If you don't want to see the slicer on the second page make sure the detail table is on top (bring to front) and make the background 0% transparent

Highlighted
Sebastien13 Visitor
Visitor

Re: Drill through - Slicers and Visual Filters

Hello everyone,

 

Rather than modifying the background of the slicer, I think the surest thing to do, is to make the slicer invisible. you can do this by sélecting the "Sync. slicer" option in the View menu, then clic to the slicer you want to hide and deactivate the view option in front of the slicer on the diffents pages (the option is the one with the eye, the other is the sychronization option).

 

But, don't forget to leave at least the slicer visible on the main page, othewise you won't be able to select any value.

 

Hope it helps.

 

Regard,

Sébastien

Helpful resources

Announcements
New Kudos Received Badges Coming

New Kudos Received Badges Coming

Kudos to you if you earned one of these! Check your inbox for a notification.

Microsoft Implementation for Communities Wins Award

Microsoft Implementation for Communities Wins Award

Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Kudoed Authors (Last 30 Days)
Users online (2,167)