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

455ab395 6d43-4032-8d43-2f69b8c5a722 on 05 Jul 2020 22:17:21

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

I need these feature too! On qlikview is the normal behaviour!

Thanks

Riccardo Muti's profile image Profile Picture

10d2565b c9ed-42b8-88c2-cc1e7f324ea4 on 05 Jul 2020 22:17:08

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

My company is considering a broader implementation of Power BI, and during demos of the product, one of the most common questions is why drilling does not filter the rest of the page. It is causing hesitation in management adoption of Power BI. We would love to see this added!

Riccardo Muti's profile image Profile Picture

2eab7d01 b9a4-461e-8338-d495a577c330 on 05 Jul 2020 22:16:51

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

This is a very important feature. It's ridiculous to look at sales for 2015 and not have a product list filter to just those products.

Riccardo Muti's profile image Profile Picture

431581a6 37a5-4ca4-bafe-46baf59d7e7a on 05 Jul 2020 22:16:28

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

We need this . Surprised that it does not work now. We are trying to recreate an SAP dashboard designer report and missing this functionality is as mentioned earlier surprising. Hopefully it will get fixed soon.

Riccardo Muti's profile image Profile Picture

911190f4 3620-4873-bdff-18a5e7806464 on 05 Jul 2020 22:16:26

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

This is a MUST have, otherwise cross-filtering will be meaningless. It would be a big plus if the tile by in charts works the same way.

Riccardo Muti's profile image Profile Picture

b3b33936 57c8-47c0-b865-63f4fdea033e on 05 Jul 2020 22:16:08

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

This feature is a must along with being able to drill down in dashboards. Also you should consider disabling the drill down button, when the chart is already showing the axis base of the hierarchy (like what is already implemented with the drill up button)

Riccardo Muti's profile image Profile Picture

61dd0c4c 00b9-4934-84a2-74a11b01fb87 on 05 Jul 2020 22:14:27

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

I want the "Single Arrow" Drill Down to drill down or cross filter other visualizations on the page. Double Arrow Drill down with link to other visualizations on the page. I am happy I can do this with the Double Arrow" Drill down, but it would make the learning curve for this tool much easier for my executive team users if they could also use the "Single Arrow" drill down button to drill down/cross-filter other visualizations on the page. This would be an advantage and benefit that Tableau does not offer today.

Riccardo Muti's profile image Profile Picture

c3218038 de8e-437c-8c45-0a906a8fccf0 on 05 Jul 2020 22:14:06

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

This idea is a must have for a visualization tool lile this and should havr been incorporated long back even before GA. Drill thorugh is not of much use on an indivdual chart, it works well when you look at combination of charts to get a clear picture. User not always focus on single visualization, rather a view to complete dashboard is required to have a full view of business/kpi etc.

Riccardo Muti's profile image Profile Picture

b4c52a02 f549-4c23-b21a-9873fe082380 on 05 Jul 2020 22:13:48

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

Please consider this feature as currently, either highlight or filter doesn't give any new insight on the data :( Also, please make this available on the dashboards.

Riccardo Muti's profile image Profile Picture

c14fed1a 17fa-493e-b7a0-8b360b025891 on 05 Jul 2020 22:13:10

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

This feature needs to be implemented soon. Vote up guys! Make them note this idea