Forum Discussion
Helper IIDrill 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.
Hi DarshanKumar ,
I wanted to follow up and see if you had a chance to review the information shared. If you have any further questions or need additional assistance, feel free to reach out.
Thank you.
Hi DarshanKumar ,
I hope the information provided has been useful. Please let me know if you need further clarification or would like to continue the discussion.
Thank you.
DarshanKumarHi Anonymous,
I tried the above unfortunately its not working. Im not able to upload the file, I have pasted the dummy data. The issue is I have two visuals, one is simple water fall chart and other one bar chart showing individual department month end HC, both the visual using the same measure and there are two filter in the sheet one with date and other one with department. when I drill through from water fall chart with only date filter selected departments are not correct and in the drill through page , however when I drill thorugh from bar chart the department is correct as the department filter is also flowing thourgh. Please can you help.
Regards,
Darshan
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.
Hi DarshanKumar ,
I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please Accept it as a solution so that other community members can find it easily.
Thank you.