cancel
Showing results for 
Search instead for 
Did you mean: 
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 III
Super User III

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





If this helps, Appreciate a KUDOS!
Did I answer your question? Mark my post as a solution!


Proud to be a Super User!




View solution in original post

3 REPLIES 3
Pragati11
Super User III
Super User III

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





If this helps, Appreciate a KUDOS!
Did I answer your question? Mark my post as a solution!


Proud to be a Super User!




View solution in original post

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?

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

March Update

Check it Out!

Click here to read more about the March 2021 Updates!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

secondImage

Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.