Need help with drill through

Hi PBIUser34 

It’s quite hard to understand exactly what you’re trying to achieve without a sample PBIX file, but in general:
Drillthrough works by filtering the target page based on the exact context of the visual from the source page.

If your dataset has six different date fields, you may need to create six separate drillthrough pages — one for each date context.

If your goal is to change or override the drillthrough context, there are some workarounds you can explore, such as the method shown in this video:
https://www.youtube.com/watch?v=BG51W2lKYIA

If your case is different, you might want to consider switching to bookmarks or a page navigator instead of drillthrough.

To get more specific help, you can share a version of your PBIX file with all sensitive data removed and upload it to any public cloud service (e.g., OneDrive, Google Drive, WeTransfer) so others can review your model structure.

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

hi PBIUser34 

A bridge dimension table is required to connect the two fact tables, and this relationship can be established either physically or virtually. For example, an Actuals table may link to the Calendar table through the Date column, while the Budget table connects through a YearMonth column since the budget data is aggregated monthly rather than daily.

Please see the attached pbix.