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

04f986d2 f371-40a5-815b-f2c04162d18b on 05 Jul 2020 22:06:46

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

This is a MUST HAVE for operational uses of Power BI on mobile. Ridiculous it is still not supported

Riccardo Muti's profile image Profile Picture

12d2aa8e fac9-41cd-a7c0-e49cd42cdac9 on 05 Jul 2020 22:06:37

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

Agreed. If you drill down in a bar chart visualization, eventually you get down to a granular lists. Showing that list as a bunch of bars with "1", filling up the screen is useless. Maybe just allow the drill down capability to change chart type at each level of hierarchy. Then you can format each level how you want to see it.

Riccardo Muti's profile image Profile Picture

e1438a68 d575-4945-bdac-b5be236b33bc on 05 Jul 2020 22:06:23

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

I agree, add that feature!

Riccardo Muti's profile image Profile Picture

71dd3f6d e1c3-435e-ad8a-196fc1aeaca3 on 05 Jul 2020 22:06:04

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

PowerBI still has a long way to catch up to Qlik and Tableau

Riccardo Muti's profile image Profile Picture

67549fdf 0408-475c-9578-3bdc0b663522 on 05 Jul 2020 22:05:10

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

Need an update on this, please.

Riccardo Muti's profile image Profile Picture

d1b80292 08f5-41c5-990a-8b472dcd7738 on 05 Jul 2020 22:04:50

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

Any update on this from Microsoft? It has been 'Under Review' since Nov 2014?!

Riccardo Muti's profile image Profile Picture

9c4e21b0 cb3d-4311-b6a5-0e2d998a47c2 on 05 Jul 2020 22:04:18

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

If you care about mobile users, like real users, like managers on the go ask them what they miss...unswer is above. Really needed. Giving 1000 votes.

Riccardo Muti's profile image Profile Picture

7c56615b 47c0-4010-acdb-93a4053c5bfd on 05 Jul 2020 22:02:14

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

I have seen a number of calls for this request since 2013. For example:

https://connect.microsoft.com/SQLServer/feedback/details/785853/power-view-cross-filtering

This behavior is so counterintuitive that it may be a deal breaker for our university. We consider this a very fundamental feature for any dashboard building technology.

Riccardo Muti's profile image Profile Picture

553c5bd8 7a9c-4328-8786-1a0e1526716d on 05 Jul 2020 22:00:34

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

Global filters/slicers would be a nice add. I would really like a way to apply one filter to all pages.

Riccardo Muti's profile image Profile Picture

0cbf6544 4ba5-41c7-9777-70d9cfdb15d1 on 05 Jul 2020 21:59:06

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

This request was brought up in the summer of 2013. Is it really still under review and not planned?