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 (232)
RE: Drill-down should drill or cross-filter other visualizations on the page
This functionality isn't available yet. The request is that the cross-filtering happens when you first drill-down, not after you turn off the drill-down mode and select something else.
If I have a map, and I've drilled into Canada, then all my other charts should be cross-filtered to Canada. Regardless of whether I've selected a province in Canada.
When I'm zoomed into Canada, I expect to see only Canadian data. And if I drill into Alberta, I expect to see only Alberta data.
It's unintuitive to have a map of Alberta cities in the center of my report, while my "top customers" table continues to show me customers who don't even live in Canada, let alone Alberta.
(Hopefully this explains the issue better)
RE: Drill-down should drill or cross-filter other visualizations on the page
This functionality is now available. You can Drill-down to the desired level, then switch off the DrillDown option and select the field you want to filter the other charts of the same page.
Nice one Power BI ;)
RE: Drill-down should drill or cross-filter other visualizations on the page
We need this or at least a workaround please
RE: Drill-down should drill or cross-filter other visualizations on the page
There are a number of things holding me back from recommending Power BI to my employer, and this is one of them.
RE: Drill-down should drill or cross-filter other visualizations on the page
It is unintuitive that you can drill-down to "2015", or "March 2015" say, but all the other visuals continue to show data from all years. Especially since, to then select an underlying item, you have to switch off the drill-down mode. This was first reported as an issue on Microsoft Connect in April 2013. I'm surprised more people aren't voting for this idea.
RE: Drill-down should drill or cross-filter other visualizations on the page
Fully agree.
Combinining Slicers and Interactiong you can get something similar, but it is not user-friendly.
You have my 3 votes.
This together TopN Filters and Show % in Donut or other similar Graph are my key priorities.
RE: Drill-down should drill or cross-filter other visualizations on the page
It really should work the way being suggested. If a function is written to show the "browse depth" of drill down chart, it should not revert to a browse depth of 1 when drilling through the first level. The isfiltered DAX function should return true as soon as drill down occurs, without having to select an underlying item
RE: Drill-down should drill or cross-filter other visualizations on the page
The filter/drill down on charts has been hard for me to even explain to users (let alone how intuitive/discoverable it is). One change that would help if Drill-Down would also cross-filter, as that seems to be the expected behavior based on most of my clients.
RE: Drill-down should drill or cross-filter other visualizations on the page
Well it isn't part of the drill down, but with the ability to Edit Interactions on the Visuals you can either have them Filter or Highlight other visualizations on the page. So if you were to select 2013 you could have your other visuals be filtered by 2013. Kind of what you are looking for to a certain degree. This is part of the Visual Tools in the Format part of the Ribbon.
RE: Drill-down should drill or cross-filter other visualizations on the page
As many have said already, would be very useful when you need a Gauge or Card etc to show a certain key metric change as you drill down through the data in your other charts.