Managing DrillThrough Filter Behavior in PowerBI Time Segments

[julsr]

Hello everyone,

I have several pie charts, each with its own DrillThrough table. One pie chart segments data by funded_date (12 months, 1 year, or 2 years). I need to modify the DrillThrough functionality so that when users click through this pie chart, it doesn't filter solely based on the clicked value (e.g., 12 months). The goal is to maintain all other visualization filters in the DrillThrough table except for the specific segment where the DrillThrough was initiated. Is there a way to achieve this?

Thanks

[Kedar_Pande]

@julsr 

Create a measure that dynamically overrides the funded_date filter using DAX. For example:

FilteredAmount = 
CALCULATE(
SUM('YourTable'[Amount]),
REMOVEFILTERS('YourTable'[funded_date])
)

Use this measure on the DrillThrough page to ignore the funded_date filter for your calculations.

💌 If this helped, a Kudos 👍 or Solution mark would be great! 🎉
Cheers,
Kedar
Connect on LinkedIn

[Ritaf1983]

Hi @julsr 
You can try to override filters of drill through manually with dax.
Please refer to the linked video:

https://www.youtube.com/watch?v=BG51W2lKYIA

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly