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

fd0c30f8 c0ec-41e7-8ae4-946a8ea934e2 on 05 Jul 2020 22:26:29

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

This would also eliminate something that seems like a bug to users:
1) Drill down a chart from Year, clicking on 2013 to expand to months.
2) Choose 2015 in a slicer. All other tiles update, however the Chart now is blank because it is filtered to 2013 and the slicer is filtered to 2015. Most users don't realize or understand what is going on.

Riccardo Muti's profile image Profile Picture

f3d94171 cea6-4046-a9f8-a23339360901 on 05 Jul 2020 22:26:27

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

Any news?

Riccardo Muti's profile image Profile Picture

4ca3b6ff b98c-4e8e-a16d-47d98e88eef4 on 05 Jul 2020 22:25:08

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

This functionality would be extremely helpful for my HR dashboard- to be able to drill down to a certain level and have headcount, turnover, and demographics data reflect the same criteria

Riccardo Muti's profile image Profile Picture

dd11ac42 c871-4f43-b2c4-c997ebc70490 on 05 Jul 2020 22:24:57

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

Yes

Riccardo Muti's profile image Profile Picture

08fc0117 944f-4ffb-9098-18d929dc8fce on 05 Jul 2020 22:24:27

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

yes

Riccardo Muti's profile image Profile Picture

0748821a a089-456f-83d0-e3a0686fd9f3 on 05 Jul 2020 22:24:20

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

YES.

Riccardo Muti's profile image Profile Picture

b08cd17f 1d77-4dd3-90ab-2f34ebdd50de on 05 Jul 2020 22:24:07

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

Is this feature availabe now ? Any ideas ?

Riccardo Muti's profile image Profile Picture

a78551b4 7a67-4083-942f-6d346756d6a5 on 05 Jul 2020 22:24:00

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

Agreed with everyone else, this is an essential feature, please address this request that has been open for over 18 months.

Riccardo Muti's profile image Profile Picture

cdc26510 d705-462f-9b69-91b7d5f06046 on 05 Jul 2020 22:23:39

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

1660 votes now.

Riccardo Muti's profile image Profile Picture

c7dc6d1a 878a-4be9-94af-78da3f643d6a on 05 Jul 2020 22:23:05

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

This is really a MUST! Other softwares like Qlik Sense and Tableau have it as the default behavior. But this great idea is open since November 2014. Microsoft: are 1585 votes (as of June 7th 2016) not enough for you to move it from "under review" to "planned"?