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.
Hi everyone. We’ve been investigating how this could work in Power BI and have a better handle on it now. It’s definitely here on our backlog although there are many other items we’re prioritizing higher (just take a look at the other ideas we’ve marked as “Started”!).
Thanks for your support of this idea – and stay tuned for more updates in the coming months.
Harry Leboeuf commented
Might be great to introduce also some smart-leveling as you can in Qlik.
What I mean by that is when on a axis there is a hierarchy and by filtering the 'page' with a slicer (ex only 1 month selected) the visual shouldn't display thear Year anymore, nor the month (because all just 1 column or dot) but directly go into the days level.
Same with categories/Sub/subsub .....
I agree with everyone. We need this. I currently have multiple reports/dashboards that have charts and it is very annoying having to drill down into each one individually.
Has this feature been implemented yet please?
Thanks for your reply.
This is huge! When is it coming?? Update?
Scott Long commented
Currently have multiple reports that need this functionality. This enhancement will achieve the 'Data Discovery' platform that you are looking for because it will allow you to slice across many levels visually to narrow down you search to a small group of items. If we don't have it people will just dump the data in excel once they realize the limitations...
I would really appreciate to have this functionality to present meaningful drill downs to our users.
Russ Loski commented
I have four visualizations on a report page. I expect that the users will expect to be able to drill all four to the same level.
Andrew B commented
I think this is a nice to have to borderline have to have feature. I would also prefer it to be able to be turned on an off depending on the functionality. For my applications, I have several Power BI dashboards that presents sales data via a Sales Org. So our org has 4 levels to it. It would be beneficial if you could drill from One level to the other and have all other visuals filter.
I have a similar problem. I have 2 tree maps and a matrix with figures on one page.
When I click on one section of the tree map, the matrix filters and shows the details of the area I have clicked on. However, if I drilled down on that section, the figures in the matrix do not change. Hopefully this will be a built in feature soon!
Hope this is coming soon. This is easily, easily done in Spotfire. Not sure why this wasn't already built in.
i really would appreciate some efforts in order to accomplish this; Thank You
Tommy Ballentin commented
Usability wise this is definitely one of the most important features, to create transparency in the more comprehensive reports. Please consider this as a high priority - For the end user, not having this feature just creates confusion.
Only just started using Power BI and have stumbled into this issue on my first report! Essential! When will it be available please?
Is this going to include: https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/10755336-multiple-cross-filter
Drill downs across multiple charts is an important feature.
Damm not again :(
Ziad Yehia commented
I think this is the last standing comparative advantage that Qlik has over powerBI, hope to see this feature in very soon as everyone else said it is a MUST !
Glad to hear this is planned...this is more critical than some might think. Big time show-stopper on a project....managers and business users don't understand why this can't be implemented.
Please add this feature. Must have!
very basic feature, must have!
This is very important , is there some workaround to do this ?