Skip to main content

Power BI

Completed

Drill-down should drill or cross-filter other visualizations on the page

Vote (2323) Share
Riccardo Muti's profile image

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)
Riccardo Muti's profile image Profile Picture

Power BI User on 05 Jul 2020 22:49:53

RE: Drill-down should drill or cross-filter other visualizations on the page

I would really appreciate to have this functionality to present meaningful drill downs to our users.

Riccardo Muti's profile image Profile Picture

Russ Loski on 05 Jul 2020 22:49:49

RE: Drill-down should drill or cross-filter other visualizations on the page

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.

Riccardo Muti's profile image Profile Picture

Andrew B on 05 Jul 2020 22:49:30

RE: Drill-down should drill or cross-filter other visualizations on the page

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.

Riccardo Muti's profile image Profile Picture

Power BI Ideas Admin on 05 Jul 2020 22:49:27

RE: Drill-down should drill or cross-filter other visualizations on the page

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!

Riccardo Muti's profile image Profile Picture

Power BI User on 05 Jul 2020 22:49:21

RE: Drill-down should drill or cross-filter other visualizations on the page

Hope this is coming soon. This is easily, easily done in Spotfire. Not sure why this wasn't already built in.

Riccardo Muti's profile image Profile Picture

Tommy Ballentin on 05 Jul 2020 22:49:00

RE: Drill-down should drill or cross-filter other visualizations on the page

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.

Riccardo Muti's profile image Profile Picture

Power BI User on 05 Jul 2020 22:49:00

RE: Drill-down should drill or cross-filter other visualizations on the page

i really would appreciate some efforts in order to accomplish this; Thank You

Riccardo Muti's profile image Profile Picture

Power BI User on 05 Jul 2020 22:48:54

RE: Drill-down should drill or cross-filter other visualizations on the page

Only just started using Power BI and have stumbled into this issue on my first report! Essential! When will it be available please?

Riccardo Muti's profile image Profile Picture

Ray on 05 Jul 2020 22:48:00

RE: Drill-down should drill or cross-filter other visualizations on the page

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.

Riccardo Muti's profile image Profile Picture

Yao on 05 Jul 2020 22:47:58

RE: Drill-down should drill or cross-filter other visualizations on the page

Damm not again :(