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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

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
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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