Forum Discussion
Cumulative Total Drill through
Super UserPlease provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information or anything not related to the issue or question.
If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Please show the expected outcome based on the sample data you provided.
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
A simplified version of the pbix file can be found here. The intent is to drill through from the line chart to the transaction detail for the selected and all previous quarters.
Here is a link to an exported csv file of what I currently get when I drill-through for the 3rd quarter for this example. I am receiving only the transactions that occurred in the third quarter.
Here is a link to the results that I am trying to achieve with the transactions for the current and all previous quarters. (First, second, and third quarters in this example.)
To complicate matters, our financial year runs October through September. The first quarter is Oct - Dec. So, I don't think that standard date functions would be useful because they work on a calendar year where the first quarter is Jan - Mar.
- lbendlin
You would create a shadow copy of your Sheet1 table, and then use that in the drillthrough target page, and use TREATAS or a measure filter to selectively transfer the filters from the drillthrough.
Thank you very much. That is exactly what I was looking for. I cannot tell you how many manhours I spent trying to figure this out.