Forum Discussion
Drill Through Issue
- 5 months ago
On your summary page chart, don't use the Created Date but instead use dimDate. That way the dimDate will be passed through as a filter to your drill through page and you can use USERELATIONSHIP to activate the appropriate relationship in each measure.
- 5 months ago
I think the best option would be using separate role-playing date tables
- DimDateCreated → active to Fact[Created Date]
- DimDateSolved → active to Fact[Solved Date]
Then use the appropriate date field for the visual / drillthrough depending on whether you want Created or Solved context.If you need both independently, this is the most reliable pattern.
Hi @Tharun95,
We would like to confirm if our community members answer resolves your query or if you need further help. If you still have any questions or need more support, please feel free to let us know. We are happy to help you.
Thank you for your patience and look forward to hearing from you.
Best Regards,
Prashanth Are
MS Fabric community support