Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

Reply
CL7777
Helper III
Helper III

Drill through doesnt work when fields are selected with a slicer

Drill through buttons do not appear to work if the field that is selected and chosen for the drill through comes from a slicer.. For example... I would like to choose a customer name from standard slicer as follows:

CL7777_0-1642100624527.png

 

When I select this customer name, I have a drill through button that is supposed to become active when I select the customer name field.. it is does not become active, meaning it does not recognize that I have selected a customer name.

 

If, however, I instead select the customer name from a table:

CL7777_1-1642100909872.png

The drill through button now becomes active and I can use it to drill through to the drill through page on that customer.

 

Why doesnt a slicer selection activate the drill through button, but the list selection does? Can I make the slicer activate the button?

 

 

 

1 ACCEPTED SOLUTION
lbendlin
Super User
Super User

No, that's not how slicers work. They are already a filter. 

 

What you can do (and what you are basically doing) is have a table visual that is controlled by the slicer, and then drill through on the table visual once you have made your slicer selection.

View solution in original post

3 REPLIES 3
Nari1998
Helper II
Helper II

Hi all,

 

I have same issue, except that i use a date slicer. When nothing is selected on the date slicer the drillthrough works perfectly well. I aslo see that it drillthroughs on all other years except for year 2023. What is the cause of this and how can it be fixed?

v-luwang-msft
Community Support
Community Support

Hi @CL7777 ,


Has your problem been solved, if so, please consider Accept a correct reply as the solution or share your own solution to help others find it.

Best Regards
Lucien

lbendlin
Super User
Super User

No, that's not how slicers work. They are already a filter. 

 

What you can do (and what you are basically doing) is have a table visual that is controlled by the slicer, and then drill through on the table visual once you have made your slicer selection.

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Dec Fabric Community Survey

We want your feedback!

Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.

ArunFabCon

Microsoft Fabric Community Conference 2025

Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.