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
'+3 from me. This is basic behaviour and shouldn't be hard to implement. The event raised when clicking one bar should also be raised when drilling down (or up, for that matter). I submitted this as a bug a long time ago, but apparently this is by design - I cannot think of a scenario where the current behaviour is what you want.
RE: Drill-down should drill or cross-filter other visualizations on the page
Filip any news if and when this basic feature is going to be included ?
It is really frustrating having to explain to users this limitation and is slowing down Power BI acceptance & roll-out.
I hope the fix will not only apply to drill down/up charts but also to all other Simple charts such that we can have multiple chart cross filter selections working together.
Eg In the proposal submitted by Riccardo add to his scenario a country dimension. Add to the report a chart Sales by Country and then select a country and ALSO drilling down to 2013 in the existing Sales by Year chart such that it would filter a separate Sales KPI 'card' to return 2013 sales for the specific selected country only.
RE: Drill-down should drill or cross-filter other visualizations on the page
According to me (and I used a lot of SSAS Frontends before) this is a bug while there is the option to use Interaction between Visuals and any way if you select a drill-down the other Visuals in the Power BI Dashboard should be changed as well !
Please fix this asap in the Sep 2016 Release !!!!
RE: Drill-down should drill or cross-filter other visualizations on the page
Yes, I just ran into this limitation. I have 4 Bar Charts in a Hierarchy showing different KPIs and I currently have to click each Bar Chart separately to drill down. And when going up and down the Hierarchy of 5 level you get lost very easily.
RE: Drill-down should drill or cross-filter other visualizations on the page
Let's get an update on this please! 2,000+ votes and under review for the last 2 years??? The best way to do this is just like the recent update to drill down. The august update broke drill down when the hierarchy drill down was added. Today there split into two different drill down buttons. Just add a third for Drill Down and Filter.
RE: Drill-down should drill or cross-filter other visualizations on the page
Any updates on this functionality? I would rather not have to build something in javascript using dc.js ...
RE: Drill-down should drill or cross-filter other visualizations on the page
Hi guys. Can you please vote for this idea as well?
I think this feature is at least as important as the one proposed in this thread. This should be standard functionality in any world class self service data visualization tool.
https://ideas.powerbi.com/forums/265200-power-bi-ideas?query=cross%20filter
RE: Drill-down should drill or cross-filter other visualizations on the page
This feature will enable power bi to go from macroscopic overview to microscopic investigation. VERY IMPORTANT!
RE: Drill-down should drill or cross-filter other visualizations on the page
I was just testing this on a report and it is till not functioning as other BI tools do. Why is this taking so long MS PBI? Cross-filtering during drill downs is a must......also i'd expect not only the drill down to filter but also any additional dimension filters onthe report to be 'added' to the fdrill down filtering of the KPI measures.
RE: Drill-down should drill or cross-filter other visualizations on the page
Must have