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

d2b7f74e ea23-4bed-9e3b-a08f81065929 on 06 Jul 2020 00:01:41

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

I too would like synchronization of drill downs on multiple charts.

Riccardo Muti's profile image Profile Picture

f0adf502 6eb4-45eb-991d-34df5d35a58f on 05 Jul 2020 23:53:26

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

Completely agree this is not complete! Need the ability to have the same drilldown effect take place on linked visuals. When I drill to month in one chart, other charts should ALSO drill, not just filter. This should be a radio button in addition to the current solution.

Riccardo Muti's profile image Profile Picture

b76423fd ec24-4079-b913-dc21803431a2 on 05 Jul 2020 23:51:53

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

problem is in the title of the idea, " ... or cross-filter ..." other visualizations, the cross-filter is there but is missing the sync drill-down, this shouldn't be marked as completed

Riccardo Muti's profile image Profile Picture

3c5f2df0 db9a-4d09-b8d5-f617435c6c9f on 05 Jul 2020 23:51:43

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

I agree with the other comments, this is 50% of the way there. I would like to be able to drill down on one visual and have the others actually drill instead of just filter :(

Riccardo Muti's profile image Profile Picture

28d6bcae 5c06-49d0-8286-c732b286d8b0 on 05 Jul 2020 23:49:08

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

It will be very useful for Data Analysis, for Executive profile perspective.
Normally Directors and Vice-Presidentes in my company are chart oriented, so we can fulfill expectations.

Riccardo Muti's profile image Profile Picture

fb1eb527 a4ba-4f80-ad7a-dcc84be33219 on 05 Jul 2020 23:48:56

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

Totally agree with the comments. The functionality it's related to sync drilling. Filter other visuals is not the same.

This really shouldn't be considered "Completed".

And other important thing it's that we can control theses interactions instead to apply to all visuals as the actual "Drilling filters other visuals" check box does.

Riccardo Muti's profile image Profile Picture

fcaff2c6 ea7a-4f84-af12-4ebdf73145cf on 05 Jul 2020 23:48:56

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

Agreed. This isn't completed yet. Want to be able to drill down through use of slicers.

Love the BI! Keep up the great work!

Riccardo Muti's profile image Profile Picture

529d75a8 9355-4257-9ada-5b642792c5c3 on 05 Jul 2020 23:44:32

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

This really should not be considered "completed".
:(

Riccardo Muti's profile image Profile Picture

93eda94d 33e2-4f7b-a38b-3e0be9bbd8e4 on 05 Jul 2020 23:41:35

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

I agree with other people. Filtering other visualisations is not the same. You should be able to sync drilling across all the visuals, especially for date hierarchy if the same source column is selected. If I click on a particular year and it drills down to quarters, other visuals show a single bar with the year selected. The desired behaviour is for other visuals to show quarters too.

Riccardo Muti's profile image Profile Picture

46e02e64 b1a0-46c8-9484-0a65da11e93b on 05 Jul 2020 23:41:16

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

This is not the same.