Brett Nodello on 19 Sep 2017 00:26:55
The current drill through capability does not appear to consider an active filter/slicer value for a visual unless the dimension being filtered is included in the parent visual. I think it would be helpful if it did.
For example; a table of customers subject to a slicer for specific stores should pass on both the customer and store values if these dimensions are both listed as drill through filters.
Administrator on 09 May 2018 05:25:11
As of the May 2018 release of Power BI Desktop you can now define your drillthrough to 'Keep all filters' which will apply the selections from slicers and other visuals to the target page as well. https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-may-2018-feature-summary/#measureDrillthrough
- Comments (52)
RE: Drill through that considers slicer/filter context of a parent visual
This is a must have. Drill down is necessary.
RE: Drill through that considers slicer/filter context of a parent visual
This is a very important feature and I hope it will be included in the next update.
RE: Drill through that considers slicer/filter context of a parent visual
This is a must have.
RE: Drill through that considers slicer/filter context of a parent visual
We need a date range that will send the customer to differnet page with the exact date range.
RE: Drill through that considers slicer/filter context of a parent visual
'+1, my customers need this
RE: Drill through that considers slicer/filter context of a parent visual
'+1
If someone is using the date ranges and is trying to drill through on e.g. customers category to see a volume of sales - it is a necessary feature.
RE: Drill through that considers slicer/filter context of a parent visual
This is super important & urgent in term of analytical story designed in Power BI and should be basic feature of any analytics tool. Please prioritize this first than any other features.
RE: Drill through that considers slicer/filter context of a parent visual
I was hoping that the December release would have fixed this major flaw. we desperately need a fix for the Drillthrough feature. We need the full context of the report including all filters and slicers to be passed to the target report.
BTW, I believe this feature should be called Drillacross not Drill through, but anyway.
RE: Drill through that considers slicer/filter context of a parent visual
It would be great if we can get an update from the PowerBI team on this request. I agree with ALL the comments below especially cbaillis that this feature is basically half built and could create major issues with end users. Please prioritize this as super urgent.
RE: Drill through that considers slicer/filter context of a parent visual
Hi relatively new to PBI.
Ditto to all the aforementioned points particularly about having working slicer and filters elements not part of the parent report. In my case, a matrix report that also allow users to select different row/column level of details.
One addition feature request is to consider having a working drill through target page report with data supported by one set of table/models that are different from the parent page report source tables, as long as the "drill through filters" or fields listed on the target page can be explicitly "matched" or defined a filter relationship from the parent to the target page report.
For example, the parent page report is a high-level summarized (by account) P&L with data come from a financial ledger table, while the target drill through page report reflects detailed information (like account, cost center, detail description, other statistical fields and etc) from a journal line table. In a typical ERS, financial data from the journal line table are posted and aggregated to the ledger table at the account level. In defining the drill through filters for the target page, one should be able to explicitly define the account field listed in the ledger table is matched with the account field listed in the journal line, cost center from ledger is matched with cost center from journal line and etc. This way, drill through to another page can effectively provide a new way of viewing different type of related detail information from tables other than those tables supporting the parent page report.