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
well, thanks for getting it done quickly, but it is not what I expected. For our case, we needed the other visuals on the page, to drill down simultaneously along with the visual where drill down happens. We have 2 visuals on the page, showing Geo, Area, Sales region hierarchy for total sales value, and another with Profit margin. The problem is, if I drill into APJ on the Sales value visual, profit margin visual, will just be filtered for APJ, not drill down to Area. I dont like it, as it does not serve the intended purpose.
RE: Drill-down should drill or cross-filter other visualizations on the page
This sounds so amazing, will check it out immediately :)
RE: Drill-down should drill or cross-filter other visualizations on the page
Excellent. Will check it out.
RE: Drill-down should drill or cross-filter other visualizations on the page
That is awesome! Looks like Christmas came early. ;-)
RE: Drill-down should drill or cross-filter other visualizations on the page
This is awesome! Looks like Christmas came early. ;-)
RE: Drill-down should drill or cross-filter other visualizations on the page
Very good news. I have build several reports all with 3-4 Visuals each. They all take advantage of the great drill Down function but it's very confusing for the users to have to active drill then drill down the hiacracy then deactive drill Down to have the Visuals syncronize.
The drill Down function syncronising on all present Visuals in the report is at "must have" - the sonner the better :-)
RE: Drill-down should drill or cross-filter other visualizations on the page
Definitely need the possibility to drill down and cross-filter by clicking on multiple visuals.
RE: Drill-down should drill or cross-filter other visualizations on the page
Please keep us posted with any progress on this. It is hugely important to get this asap.
RE: Drill-down should drill or cross-filter other visualizations on the page
'+1 for the feature. This would help close the gap between PowerBI and Tableau so hopefully this feature can move up in the priority list as I imagine a lot of BI analysts want to include in their respective projects. Lots of demand for this.
RE: Drill-down should drill or cross-filter other visualizations on the page
'@Will Thompson
Can you provide more details on exactly how the team is planning to implement this. I think this is perhaps the most crucial feature and needs to be implemented right. Not sure the description of this idea is clearly stating the cross-filter aspect so want to be sure. From a cross-filtering standpoint, the scenario is
- I have a chart with say 4 visuals
- I click on say a bar within Chart 1 -> All the visuals filter accordingly
- I then click on a column in Chart 2 -> All visuals filter based on the selection in Chart 1 and Chart 2 (currently chart 1 filter goes away at this point)
Basically, filters need to stick or there needs to be an ability for the user to maybe pin a filter. Latter option would be more flexible.