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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

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
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Fabric Monthly Update - May 2024

Check out the May 2024 Fabric update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.