Drill-down should drill or cross-filter other visualizations on the page
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.
We’ve begun work on this feature! Our plan is to filter visuals that would be cross-filtered or cross-highlighted when you select in the first visual. That way, if you use Edit Interactions to turn off filtering/highlighting, drilling won’t impact it either.
Stay tuned for updates!
Henrik Hougaard commented
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 :-)
Definitely need the possibility to drill down and cross-filter by clicking on multiple visuals.
Please keep us posted with any progress on this. It is hugely important to get this asap.
+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.
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.
Helfried Stibal commented
This would be a great leap for reporting.
Sakshi Goel commented
Drill down should cross-filter other visualization.I need this feature for my web analytics.This will help me to use Filled map as a filter.and multi selection of state,city in case of drill down is also required.Please let me know when are u releasing this feature?It will be a great help and contribution from your side.
Michael Dyckman commented
+1 for this feature
Matew Sbovata commented
It's an absolute necessity to get this new function.
Bernhard Zauner commented
This function is an absolute hygiene factor for intuitive analysis - please prioritize this
Alex Ham commented
Can i haz this plz
Martin Møldrup commented
I really need this, I hope you will start it soon.
Yudesh Partab commented
Anthony Cipolla commented
....just discovered that Pivot Table Drill downs don't affect other visuals!!!! Looks likes this is affecting lots of folks.... Please can this be reprioritised????
Ryan Holt commented
Is there any further progress on this? This is currently VITAL to our fault analysis of equipment failures. This is a must have for us. As mentioned below Tableau already does this and if we cant get it in PowerBI may have to change back to Tableau.
Saur Dash commented
I have just had to massively limit the interactivity of a dashboard I have built for my company due to this missing vital component. This functionality is integral to the Power BI user experience and I am stunned that it still hasn't been implemented.
Hi, Is there any way we can sort this out? or like in how much time will this be available? I am facing the same issue.
I transitioned from Tableau to PowerBI and this feature was very good which gives a very interactive experience to users. Users also like it instead of selecting multiple drop down filters...
Chethan K commented