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

8c071cf5 b8bc-4fba-8eae-92a7281d6fe6 on 06 Jul 2020 00:18:07

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

it's a necessary requirement. pls solve it in next update

Riccardo Muti's profile image Profile Picture

e19187bd 1496-47ba-a378-ecf8460d98d4 on 06 Jul 2020 00:16:01

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

No sync for drill-down feature yet. This is a serious need that would be of great value if addressed!

Riccardo Muti's profile image Profile Picture

8cc57dc4 6c9f-4065-8ba2-cf5997e7bf25 on 06 Jul 2020 00:14:37

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

PLEASE reopen this ticket, Will. This feature is NOT complete.

Riccardo Muti's profile image Profile Picture

8cc57dc4 6c9f-4065-8ba2-cf5997e7bf25 on 06 Jul 2020 00:14:37

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

Please, follow and vote for the feature here:
https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/31089574-synchronize-drill-up-down-of-visualizations

Riccardo Muti's profile image Profile Picture

571b7135 60df-4fdc-9436-697def133b53 on 06 Jul 2020 00:14:36

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

This is not what we were expecting, We need the "expand hierarchy" to apply to all visuals at the same time

Riccardo Muti's profile image Profile Picture

b548bbf9 9721-4e68-8cdf-259b870f3629 on 06 Jul 2020 00:14:15

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

The present solution is not what we hoped for unfortunally. The other visuals need to be at the same level of detail, not just filter.

Riccardo Muti's profile image Profile Picture

b548bbf9 9721-4e68-8cdf-259b870f3629 on 06 Jul 2020 00:14:15

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

PLEASE reopen this ticket, Will. This feature is NOT complete.

Riccardo Muti's profile image Profile Picture

89330877 1c34-4fa7-b05d-32e3625a7719 on 06 Jul 2020 00:13:02

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

Pinging the fact that this feature is not truly complete. We need other visuals to "drill down" too.
Ex - I have a spark line next to a bar graph, if I drill one level down into the bar I would love to have the spark drill one level down as well.

Riccardo Muti's profile image Profile Picture

2c08f769 5e47-4ad0-b27d-992e2095446e on 06 Jul 2020 00:06:27

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

The present solution is not what we hoped for unfortunally. The other visuals need to be at the same level of detail, not just filter.

Riccardo Muti's profile image Profile Picture

c92f549d acf9-4840-8052-4dbf50d8b54a on 06 Jul 2020 00:04:06

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

PLEASE reopen this ticket, Will. This feature is NOT complete.