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

c47a8466 e165-40cd-b48a-074ce8894783 on 05 Jul 2020 22:47:11

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

Glad to hear this is planned...this is more critical than some might think. Big time show-stopper on a project....managers and business users don't understand why this can't be implemented.

Riccardo Muti's profile image Profile Picture

2ba6de2f dbae-4c9f-b654-424d4f5f89d8 on 05 Jul 2020 22:46:54

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

Please add this feature. Must have!

Riccardo Muti's profile image Profile Picture

0b9cc353 29bb-42d4-bdcd-25267c86b623 on 05 Jul 2020 22:46:46

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

This is very important , is there some workaround to do this ?

Riccardo Muti's profile image Profile Picture

a2a849a6 336a-467e-8016-176ffd0c74d8 on 05 Jul 2020 22:46:46

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

very basic feature, must have!

Riccardo Muti's profile image Profile Picture

36dbe816 7e42-43df-8c0a-09932d64926c on 05 Jul 2020 22:46:10

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

We are presenting this as a concept to our CEO and this is a MUST have to get sign off for the tool!

Riccardo Muti's profile image Profile Picture

b192286c ccbb-475e-9ec1-45205444a45f on 05 Jul 2020 22:46:08

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

Definitely a make-or-break feature for us where several projects are concerned.

Riccardo Muti's profile image Profile Picture

a8b552d9 8bbd-48ba-9c50-04698b1b279e on 05 Jul 2020 22:46:02

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

it's very important this!!!

Riccardo Muti's profile image Profile Picture

994f0286 648d-447f-8e24-44afa70776a7 on 05 Jul 2020 22:45:56

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

Highly appreciated. My workaround is now one big view instead.

A decent SSAS tabular shows inconsistent data, because the filtering is not applied to other visuals.

Riccardo Muti's profile image Profile Picture

0571339e ce11-4aec-ab57-eda543aa3376 on 05 Jul 2020 22:45:36

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

Every time I present Power BI to my colleagues that have in charge to sell it do clients they ask me: "what about the killer feature 'contextual drilldown'? MS has decided to develop it?".

When I answer "not yet" then they conclude "well, let's propose Qlik...".

Please, PLEASE, prioritize it!

Riccardo Muti's profile image Profile Picture

03794c72 cfaf-4a2f-b4f5-c7890d7e480c on 05 Jul 2020 22:44:40

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

By when this feature would be available?