Power BI
CompletedDrill-down should drill or cross-filter other visualizations on the page
Riccardo Muti on 13 Nov 2014 09:59:48
I have a report page with multiple charts and visualizations. Let's say one of the chart shows Sales by Year and I drill down into 2013 to see the sales by month in 2013. Currently, the drill-down has no effect on the other charts and visualizations on the page; they still show data for all years, not just for 2013. Instead, I'd like other charts to drill down into 2013 or filter by 2013 as well.
Administrator on 12 Dec 2017 13:20:43
Well this is exciting! We've just shipped the December release of Power BI Desktop, and I'm very pleased to say we've added the ability to apply filters from a visual when you drill into it. This is now the default for any new visuals; you can turn it on for existing visuals (or disable it if you don't want it) through the Format tab. Look for "Drilling filters other visuals". Hope you like it! thanks!
- Comments (233)
RE: Drill-down should drill or cross-filter other visualizations on the page
I have a presentation with 3 piles in a diagram. One is the actual result, one is the budget and one is the difference. The bottom level of the actual result is on transactions (account).
The budget is on group level (group of accounts). This works excellent on the group level.
But if I do a drill down an the actual pile to see data on a account level the presentation also will include the budget on account level which is of no use in this case. In this case I only want to drill down on the actual result by a right click on the actual pile. Is there a solution to this need I might have missed or will it be implemented in a future version? The solution now is an extra chart with only a result pile there the drill down function works very well.
RE: Drill-down should drill or cross-filter other visualizations on the page
Seems like this should be a no brainer - lack of the interactions under drill-down significantly diminishes the usefulness of the interactions.
RE: Drill-down should drill or cross-filter other visualizations on the page
Unhappy that the visualizations drill through is not updating the linked visual objects i.e. tables even though the filter shows as being applied.
RE: Drill-down should drill or cross-filter other visualizations on the page
No news from May??
RE: Drill-down should drill or cross-filter other visualizations on the page
Great to see all new features in the Sep 2016 Power BI Desktop Release, but still the problem with Drill-Through is not solved and so the Dashboards are not working as it should be for new and existing users/customers.
Please take attention that bug fixing and enhancements to existing visuals are far more important than adding new features (which might also be fixed) in this stage of product development of Power BI Desktop.
Please add this to the coming Oct 2016 Release as fixed !
RE: Drill-down should drill or cross-filter other visualizations on the page
I'm fairly new to Power Bi and came across this limitation almost immediately. I thought I was doing something wrong at first because it seems like such an obvious function to have. I hope it gets implemented ASAP.
RE: Drill-down should drill or cross-filter other visualizations on the page
Absolutely needed to help everyone better understand the data they are looking at.
In the mean time, if there are any best practices around how to tell a data story well without this ability, I would appreciate that.
RE: Drill-down should drill or cross-filter other visualizations on the page
Can we please have an update on this? I want to give my users the ability to interrogate the data themselves. I agree with @David. It's not ideal that I have to explain to my users that they can drill... but with limitations.
This feature should be stock standard as is lassoing. There are other tools that provide this functionality
RE: Drill-down should drill or cross-filter other visualizations on the page
We would like to have this solved asap in sep or oct 2016 Release !
Working Interactive Dashboard based in ReportPortal for SSAS 2016 Tabular:
http://reportportal.us/ReportPortal/dashboard2/Design.aspx?reportId=1614
RE: Drill-down should drill or cross-filter other visualizations on the page
I honestly cannot believe PowerBI has this limitation.