Filters not working as intended on drill-through page

[fionabee]

I have a dashboard which has a page with a stacked bar chart, that contains items that are in and out of SLA. There is a filter on this entire visual to only show the last 12 months. When I drill through on the chart to see the cases in a specific month that were within SLA, the drill-through page shows items that do not fall into the criteria that I've highlighted. 

I'm right clicking my card and expecting to see 11 but actually I see all items for all of time which within SLA. 

Filters on the card:

Filters on the drill through:

I'm not sure what I'm doing wrong as have never noticed filters on drill-throughs not working before? 

[Praful_Potphode]

Hi @fionabee ,

try turning on keep all filters to ON.

check if the date column used in last 12 months and drillthrough page are same.

Please give kudos or mark it as solution once confirmed.

Thanks and Regards,

Praful

[rohit1991]

Hii @fionabee 

Drill-through ignores page-level filters unless the same fields are also present on the drill-through page. Your main page is filtered to “last 12 months,” but that filter is not being passed because the drill-through page doesn’t contain the Created On or Included (Within SLA) fields in the drill-through setup. Add those fields to the drill-through page’s “Drill-through fields” well, or recreate the same filters on the drill-through page. Once the drill-through page has the same context fields, it will correctly show only the 11 records instead of all SLA-matched records.

Below example:

[fionabee]

Hello - everything that is a filter on that card is also included in the 'drill-through' fields and 'keep all filters' is on and I'm still seeing the incorrect items on the drill-through page. Is there anything else it could be?

[v-menakakota]

Hi @fionabee ,

Thanks for confirming the fields are already in the drill-through setup. In this case, the issue is that drill-through does not always carry over visual-level filters (like your Last 12 Months filter from the main page). That’s why you see more SLA records than expected.

To fix it, please apply the same filters directly on the drill-through page:

On the Drill-through page → Filters pane:

Add Created On → set to Last 12 Months

Add Within SLA filter → Yes

Add Status filter → Not Cancelled (if used)

And keep Keep all filters turned ON.

Once the drill-through page has the same filter context, the record count should match the main page (like the 11 shown in the card).

Best Regards, 
Community Support Team

[v-menakakota]

Hi @fionabee ,

Thanks for reaching out to the Microsoft fabric community forum. 

I would also take a moment to thank @rohit1991     , for actively participating in the community forum and for the solutions you’ve been sharing in the community forum. Your contributions make a real difference.

I hope the above details help you fix the issue. If you still have any questions or need more help, feel free to reach out. We’re always here to support you 

Best Regards, 
Community Support Team