Drill-down and drill-through in Power BI - Practice Problems & Coding Challenges

Challenge - 5 Problems

🧠 Conceptual

intermediate

Understanding Drill-Down Behavior

In Power BI, what happens when you use the drill-down feature on a hierarchical chart?

A The chart replaces the current view with the next level of detail for the selected category, hiding the higher levels.

B The chart expands to show the next level of detail within the selected category, keeping the higher levels visible.

C The chart filters to show data only for the selected item, removing all other levels.

D The chart shows a popup with detailed data but does not change the chart view.

💡 Hint

Think about how drill-down changes the chart's level of detail.

Drill-down replaces the current chart view with the next level of detail for the selected category, hiding the higher levels to focus on the detailed data.

❓ dax_lod_result

intermediate

DAX Measure for Drill-Through Filtering

You want to create a DAX measure that counts sales only for the product selected in a drill-through page. Which measure correctly respects the drill-through filter context?

Power BI

Measure = COUNTROWS(Sales)

A Measure = COUNTROWS(Sales)

B Measure = CALCULATE(COUNTROWS(Sales), ALL(Product))

C Measure = CALCULATE(COUNTROWS(Sales), VALUES(Product[ProductID]))

D Measure = CALCULATE(COUNTROWS(Sales), REMOVEFILTERS(Product))

💡 Hint

Drill-through passes filters automatically. Which measure respects current filters?

Using COUNTROWS(Sales) respects the current filter context, including drill-through filters. Using ALL or REMOVEFILTERS removes filters, ignoring drill-through.

❓ visualization

advanced

Best Visualization for Drill-Down Experience

Which visualization type in Power BI provides the best user experience for drill-down on hierarchical data?

A Pie chart with drill-down enabled

B Card visualization showing aggregated value

C Stacked bar chart with hierarchy enabled

D Table visualization without hierarchy

💡 Hint

Consider which chart type naturally supports hierarchical drill-down.

Stacked bar charts support hierarchies and allow users to drill down into categories smoothly, making them ideal for drill-down experiences.

🔧 Formula Fix

advanced

Troubleshooting Drill-Through Filter Not Applying

You created a drill-through page in Power BI but when you drill through, the page shows all data instead of filtered data. What is the most likely cause?

A The data model does not have relationships between tables.

B The source visual does not have any data selected before drilling through.

C The drill-through page has too many visuals causing performance issues.

D The drill-through filter field is not added to the Drill-through filters well on the target page.

💡 Hint

Check the drill-through page filter settings.

Drill-through requires the filter field to be added to the Drill-through filters well on the target page to apply the filter context.

🎯 Scenario

expert

Designing Drill-Down and Drill-Through for Sales Analysis

You have a sales report with a hierarchy: Region > Country > City. You want users to drill down from Region to City and also drill through to a detailed sales transaction page filtered by the selected city. Which setup correctly supports both drill-down and drill-through?

A Create separate charts for each level and link them with bookmarks; no drill-through filters needed.

B Enable hierarchy drill-down on the Region-Country-City chart and add City field to the Drill-through filters on the transaction page.

C Use slicers for Region, Country, and City and disable drill-down; add Region to Drill-through filters only.

D Enable drill-down on the chart but do not add any fields to Drill-through filters; rely on slicers on the transaction page.

💡 Hint

Think about how drill-down and drill-through filters work together.

Enabling hierarchy drill-down allows users to explore data levels. Adding City to Drill-through filters ensures the transaction page filters correctly when drilling through.