Single-click drill through?

[wcarter]

Looking for help with this, maybe if anyone has an idea if it's on the roadmap, etc.

When it comes to education and the data visualization space, every product targeting that market has the ability to go from high level aggregate views to detailed views on individual students with a single click. For example, a table might list students with columns for name, attendance rate, gpa, and discipline count. In edu data viz products each of those values would be a link taking you to a profile of the student, the student's attendance details, the student's grade history, or the student's discipline activity. In power bi, as far as I can tell, the user has to know that they can right click on the data value, go down to drill through, and select the page to go to, or I would need to set up a drill through button for each of those columns and the user would have to select the specific cell and then click the button. Neither of these are as obvious in function to the average user with limited pbi experience as the value in the table being a link they can click on.

Is there any way in the product currently to do what I need to do to make drill through as frictionless as possible for my users, and if not does anyone know if it's planned for future development? 

Thank you for any and all help with this!

[wcarter]

Cool, I guess it'll do until drill through links or cell-based conditional bookmarks become a thing.

[danextian]

Hi @wcarter 

This isn't currently possible with just a click. Drillthough option can be accessed from the following:

-right clicking a visual a datapoint

-via auto-generated tooltip

-or by using a drillthrough button which can only be activated if a datapoint in a visual is clicked.

[wcarter]

Can one button be linked to multiple drill through pages, changing the destination based on which value was selected in the visual?

[danextian · Accepted solution]

Per testing, it is possible via conditional formatting. The measure should contain the page name.  

drillthrough page = IF(HASONEVALUE(Dates[Month and Year]), "moyr", "details")

[lnguyen2025]

Hi,

Could you please provide more detail as of how to implement it using the measure.  Thank you so much.