Drill Through not returning correct values

Hi again DarshanKumar ,

Thank you for your clear explanation of the issue. I fully understand the confusion. The core reason is that Power BI only sends filters to the drill-through page based on the fields present in the visual where you initiate the drill-through. When you use the bar chart, which includes the department field, Power BI passes the department filter as expected. However, in the waterfall chart, since the department isn’t included, it doesn’t pass that filter resulting in incorrect departments on the drill-through page.

To address this effectively, I recommend creating a separate table for departments (a disconnected slicer) and building your visuals with a measure that references the selected department from this slicer. This ensures both the bar chart and waterfall chart respond to the slicer, regardless of whether the department field is present in the visual. On the drill-through page, include the same slicer and avoid adding the department field to the drill-through pane. This approach guarantees the department filter is always applied correctly, providing consistent and accurate results across all visuals and drill-through pages.

Thank you,

Tejaswi.