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
Paulyeo11
Impactful Individual
Impactful Individual

Any different between Drill down and drill through ?

Hi All

Does the above 2 mean the same ?

Paul

1 ACCEPTED SOLUTION
ctaulbee
New Member

Drill-down is used in a single visual. You can create a hirearchy within a single visual that lets you visualize data at the highest level, then let users drill-down into the lower levels of the data to get more details if they want it.

For example, you have a column chart that shows you total sales by Location. You could add in your axis field the product type for each location so that when a user drills down into each location, they could see all of the products sold in that location within that same visual.

https://docs.microsoft.com/en-us/power-bi/consumer/end-user-drill

 

Drill-through is a feature that applies the filters of a selected data item and applies that through to the page that you're drilling through to. 

 

 

 

For example, you have a tab within a report that has column chart with all locations and total sales. You have another tab with a table that has a list of all products sold and that page is enabled for drill through on the location field. When you're on the column chart tab, you can right click a location within your column chart and select to drill-through to that other tab with your table and it will apply the filter to that table for the location you were selected on.

 

https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-drillthrough

View solution in original post

1 REPLY 1
ctaulbee
New Member

Drill-down is used in a single visual. You can create a hirearchy within a single visual that lets you visualize data at the highest level, then let users drill-down into the lower levels of the data to get more details if they want it.

For example, you have a column chart that shows you total sales by Location. You could add in your axis field the product type for each location so that when a user drills down into each location, they could see all of the products sold in that location within that same visual.

https://docs.microsoft.com/en-us/power-bi/consumer/end-user-drill

 

Drill-through is a feature that applies the filters of a selected data item and applies that through to the page that you're drilling through to. 

 

 

 

For example, you have a tab within a report that has column chart with all locations and total sales. You have another tab with a table that has a list of all products sold and that page is enabled for drill through on the location field. When you're on the column chart tab, you can right click a location within your column chart and select to drill-through to that other tab with your table and it will apply the filter to that table for the location you were selected on.

 

https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-drillthrough

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.