Forum Discussion
Drill through not working
Hello,
I am trying to build a drill through.
I want to drill through the value 395 as pointed by arrow in this image.
When I click on IB Details, i get this. You can see the Dealer ID slicer has not been filtered at all to "DXB" and the Value Date slicer has also not been filtered as it is still showing 2027.
Everything in the IB Details page (i.e. the page you are trying to get to when you click on Drill Through) comes from AllRevenueIBsTbl as shown in the arrow in the image below which is my model:
The cell you click on that contains the value 395 for which you want to drill into, uses the following tables in its filter context:
- DimDealers (to get the dealer id and dealer name)
- DimCalendar (to get the monthYear)
- IBCommsFinal (uses the IBPaid field in a measure)
The DimDealers and DimCalendar filters the IBCommsFinal table and then IBCommsFinal filters the AllRevenueIBsTbl, right? So The connection is all there for filter propagation, right?
Thanks in advance
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information. Do not include anything that is unrelated to the issue or question.
Please show the expected outcome based on the sample data you provided.
Need help uploading data? https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
7 Replies
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information. Do not include anything that is unrelated to the issue or question.
Please show the expected outcome based on the sample data you provided.
Need help uploading data? https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523Hi mp390988 ,
just by looking into image and understanding it is difficult.but i will try to list out common problems.
- i think there is a filter mismatch on the target drilthrough page.If you see the year and date filters they are all different.
Date (07/11/2022 - 07/11/2025)
MonthYear (is Jan-25)
Year (is greater than or equal to 2025)
Year (is 2025)You have kept Keep all filters on the drillthrough page so it brings every filter from source.make sure filters are able to filter the target page.ideally the date filters should come from Calendar table
- Check Columns of all slicers on source page and drill through page.make sure they are same(DealerID should come from same table on both pages).
- Check Sync Slicer and Edit Interactions.
- Check Relationship are working fine.one quickway to test it to pull all relationship columns in table visualizations.(try creating relationship from AllRevenueIBsTbl to DimDealers and DImCalendar).
Try below steps to confirm filtering
- On the IB Details page, add a card visual using SELECTEDVALUE(DimDealers[DealerID])
Drill-through again and see if this card shows "DXB" - If it shows "DXB", then the filter IS working, but your slicers are not responding to it
- If it shows blank, then the filter is NOT reaching the DimDealers table
Experiment with this and it shoudl work.
Please give kudos or mark it as solution once confirmed.
Thanks and Regards,
Praful
Hi mp390988 , Thank you for reaching out to the Microsoft Community Forum.
As lbendlin mentioned, we cannot give you the correct solution without all the relevant details including sample data. But from what we can see from what you have given, Praful_Potphode is correct, the issue comes from mismatched filters on the drill-through page and that your slicers probably use different columns than the ones being passed from the source. Their suggestion to test with SELECTEDVALUE(DimDealers[DealerID]) is useful to confirm if the DXB filter is actually reaching the page.
Power BI only carries context for the exact fields in the Drill-through well. So, on your IB Details page, add DimDealers[DealerID] and a DimCalendar field (Date or MonthYear) to that well. Then, rebuild your slicers using those same Dim columns, not from AllRevenueIBsTbl. Otherwise, the page will filter correctly but the slicers will still show All. Also, check relationships, make sure DimDealers -> AllRevenueIBsTbl and DimCalendar -> AllRevenueIBsTbl are active and single-direction. Don’t rely on IBCommsFinal to propagate filters, since it behaves like a fact table and won’t pass context properly. Finally, simplify your page filters to a single time level (either Date or MonthYear).
Thank you lbendlin & Praful_Potphode for your valuable responses.
Hi mp390988 , hope you are doing great. May we know if your issue is solved or if you are still experiencing difficulties. Please share the details as it will help the community, especially others with similar issues.
Hi mp390988 , Hope you're doing fine. Can you confirm if the problem is solved or still persists? Sharing your details will help others in the community.
there is no drill down option in visualisation. so, i can't make any drill down. please solve this asap.
