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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
webportal
Impactful Individual
Impactful Individual

Power BI Service "Explore" "Drillthrough"

Hello,

 

Can someone please explain what is the function of this menu item in Power BI Service?

 

Drilltrhough "ON" or "OFF"?

 

Capturar.PNG

 

I know Drill Down and Drill Up, but Drillthrough doesn't seem to make sense.

 

I also know what this other "Drillthrough" filter is doing, but can't understand the logic between these two...

 

Capturar2.PNG

 

Thanks for helping! 🙂

1 ACCEPTED SOLUTION
v-frfei-msft
Community Support
Community Support

Hi @webportal,

 

Based on my test, if you turn the option on, then you can dirllthrough to the target page by left clicking any item in the visual apart from right clicking the item to drillthrough report. If you turn the option off, you are only able to right click the item in the visual to dirllthrough report.

1.png2.png

 

For the Dirillthrough here, it will display all the columns that the page are filtered by if you turn it on. Conversely, then it will only display the original one (Name) all the time.

 

3.png

 

In general, there is no logic between the two ones.

 

Regards,

Frank

 

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the others find it more quickly.

View solution in original post

3 REPLIES 3
v-frfei-msft
Community Support
Community Support

Hi @webportal,

 

Based on my test, if you turn the option on, then you can dirllthrough to the target page by left clicking any item in the visual apart from right clicking the item to drillthrough report. If you turn the option off, you are only able to right click the item in the visual to dirllthrough report.

1.png2.png

 

For the Dirillthrough here, it will display all the columns that the page are filtered by if you turn it on. Conversely, then it will only display the original one (Name) all the time.

 

3.png

 

In general, there is no logic between the two ones.

 

Regards,

Frank

 

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the others find it more quickly.

Is there a way to keep it on by default? I want it always on whenever I open the report by default. Is that possible?

Since last Fri., we found out that right click is not working anymore with the report deployed to PowerBI service. Only this Explore -> DrillThrough -> left click is working. Is there sth. change with PowerBI service?

Can we get back right click for the context menu or at least set the Drillthrough defaul is on.

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

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

Top Solution Authors
Top Kudoed Authors