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

See when key Fabric features will launch and what’s already live, all in one place and always up to date. Explore the new Fabric roadmap

Reply
LJAdmin
Regular Visitor

Enable Drill Through BUtton from slicers selected value

Hi,

 

i've a question regarding the "new" drill-through button;

Is it possibile to use a drop-down list slicer to select the drill-through value and then click on button to go to the drill-though page?

I've tried so many different ways, but the button only works if i select the value from a table from example. If i select the value from the slicer the button remains greyed.

 

Thank in advance for the help,

--Dennys

1 ACCEPTED SOLUTION
Pragati11
Super User
Super User

Hi @LJAdmin ,

 

That's the functionality constraint on how the drill-through buttons work in Power BI. You have to click on a single data-point for it to work.

https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-drill-through-buttons

 

Thanks,

Pragati

Best Regards,

Pragati Jain


MVP logo


LinkedIn | Twitter | Blog YouTube 

Did I answer your question? Mark my post as a solution! This will help others on the forum!

Appreciate your Kudos!!

Proud to be a Super User!!

View solution in original post

6 REPLIES 6
BradleyBI
Regular Visitor

Would love to get this bumped up. With the introduction of the new button slicer this functionality would greatly enhance the user experience. The new slicer allows for a "netflix style" scroll experience to control the data on the screen and if you want the slicer itself to represent the data then it makes sense to allow for enabling of the drill through button if there is only a single selected value similar to selecting a value from a table and proceeding to the detail page from there. 

Pragati11
Super User
Super User

Hi @LJAdmin ,

 

That's the functionality constraint on how the drill-through buttons work in Power BI. You have to click on a single data-point for it to work.

https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-drill-through-buttons

 

Thanks,

Pragati

Best Regards,

Pragati Jain


MVP logo


LinkedIn | Twitter | Blog YouTube 

Did I answer your question? Mark my post as a solution! This will help others on the forum!

Appreciate your Kudos!!

Proud to be a Super User!!

Anonymous
Not applicable

The only limitations I saw were listed at the bottom of the page and since a Slicer is a 'Built-in visual' and selecting a list object allows the right click drilldown method from that item. If the drilldown didn't work in the slicer the old fashion way, I would agree that the button version wouldn't be supported either.  But since it is, this seems more like a critical oversight by MS or a flat out bug.

 

I just joined the community looking for a solution for this problem.  If anyone has found a work around for this it would be very appreciated.  🤔  If I figure one out I'll definitely report back here with it.

 

Thanks!

Hi, just to bump this topic. Did anyone find a solution?

 

I'm needing to build a drillthrough based on images (I was going to use a chiclet slicer).

 

@Microsoft, saying selecting a single value via a slicer rather than other visual is pretty poor. This is surely not working as intended?

I am wondering the same thing. Has anyone found a solution for this yet? Or even a workaround?

 

Thanks

Looking for a solution, bump.

Helpful resources

Announcements
May PBI 25 Carousel

Power BI Monthly Update - May 2025

Check out the May 2025 Power BI update to learn about new features.

May 2025 Monthly Update

Fabric Community Update - May 2025

Find out what's new and trending in the Fabric community.