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

d82187f2 d831-4526-97eb-c7af637fabb5 on 05 Jul 2020 22:49:49

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

I have four visualizations on a report page. I expect that the users will expect to be able to drill all four to the same level.

Riccardo Muti's profile image Profile Picture

ec6ad083 b7cd-482a-a41a-9922d7b5f802 on 05 Jul 2020 22:49:30

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

I think this is a nice to have to borderline have to have feature. I would also prefer it to be able to be turned on an off depending on the functionality. For my applications, I have several Power BI dashboards that presents sales data via a Sales Org. So our org has 4 levels to it. It would be beneficial if you could drill from One level to the other and have all other visuals filter.

Riccardo Muti's profile image Profile Picture

a3309361 99be-ea11-a812-000d3a8ddfb2 on 05 Jul 2020 22:49:27

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

I have a similar problem. I have 2 tree maps and a matrix with figures on one page.
When I click on one section of the tree map, the matrix filters and shows the details of the area I have clicked on. However, if I drilled down on that section, the figures in the matrix do not change. Hopefully this will be a built in feature soon!

Riccardo Muti's profile image Profile Picture

0378e257 1fcc-4571-9fce-32e268a7a812 on 05 Jul 2020 22:49:21

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

Hope this is coming soon. This is easily, easily done in Spotfire. Not sure why this wasn't already built in.

Riccardo Muti's profile image Profile Picture

0743e767 97dd-4a3f-b45a-ed3e054ab5b8 on 05 Jul 2020 22:49:00

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

Usability wise this is definitely one of the most important features, to create transparency in the more comprehensive reports. Please consider this as a high priority - For the end user, not having this feature just creates confusion.

Riccardo Muti's profile image Profile Picture

226722e0 0deb-44c0-b663-570087a04abd on 05 Jul 2020 22:49:00

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

i really would appreciate some efforts in order to accomplish this; Thank You

Riccardo Muti's profile image Profile Picture

00c04b1e 6aa0-4524-93b2-53f295e6ae03 on 05 Jul 2020 22:48:54

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

Only just started using Power BI and have stumbled into this issue on my first report! Essential! When will it be available please?

Riccardo Muti's profile image Profile Picture

d89b1cc5 6b2f-4a09-9a75-1276db9904c9 on 05 Jul 2020 22:48:00

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

Is this going to include: https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/10755336-multiple-cross-filter

Drill downs across multiple charts is an important feature.

Riccardo Muti's profile image Profile Picture

f53297f6 bd92-418a-a727-227a5902ee3f on 05 Jul 2020 22:47:58

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

Damm not again :(

Riccardo Muti's profile image Profile Picture

7a05e6ea 8e35-e711-80f9-c4346bac219c on 05 Jul 2020 22:47:56

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

I think this is the last standing comparative advantage that Qlik has over powerBI, hope to see this feature in very soon as everyone else said it is a MUST !