Visual filtering

[Gk-1]

Hi everyone,

i have a problem.

I've a bar chart with 2 levels of details on X-axis that i can drill down correctly.

I've got also a table, which contain the same data of bar chart.

When i select a bar on the chart, i can see the related data into che table, sorted by the top layer on the bar chart, which is "week number". Then i deselect the bar.

When i drill down, for example "week 40", the bar chart change corretcly, but not the table, that remains the same, not filtering the item by "week 40".

When i'm in the second layer, which is "items produced" (in week 40, in bar chart), whenever i select another bar (that should be filtered by "week 40" and "item") the table return the correct filter "item" but not "week 40".

How can i accomplish this thing?

It seems that the visual level filter of the bar chart don't carry to the filter of the table.

Thanks.

[JBeyers]

So let me get this straight: when you perform a drilll-down, you want to filter the results in all other visuals/tables/charts/.. on the same report?

I'm also looking for this, but I guess this is not (yet) available. 

[Gk-1]

yeah, more or less...

maybe is still unavailable

[markvsql]

Currently, with the drill-down capability, it is essentially a mode you turn on or off. So, you can either have cross-filtering (the default) and filter other visuals on the page by clicking parts of the visual in question. OR you can turn on Drill-Down and click on that visual will drill down to another level. So, at present, it is one or the other. 

I agree that this is not ideal. I'm hoping they will make this better in a future release.

[ragingaardvark]

I'd like to weigh in on this - as it's not actually working correctly anyway;

I have a pie chart with the following drill ;

• Heirarchy of Year, Quarter, Month, Day
• Category of reason for error
• Resolution

There is a slider to select for issues that it;

• All
• Closed
• Open

Then a table that displays the item number  - so that, if I find a bunch of issues that the same error category but no resolution, I can see the respective item numbers to find out why.

The slider works fine across both other visuals.

The Pie chart drills all the way down correctly.

I can unclick the drill-down arrow in the Pie chart to then click on part of it to filter the table of item numbers.

Problem is though, if I drill to 2015, uncheck the drill arrow, click on Quarter 3 I get quarter three for every year in the table of item numbers - not just the Quarter three for 2015.

[leonardmurphy · Accepted solution]

@ragingaardvark: I agree it's not working as you'd expect it to.

What you're expecting is that, when you drill down, it filters all the other visualizations based on how you've drilled. E.g. if you've drilled down to 2013, all the other charts are filtered to 2013. And then when you select Q3, the other visualizations are filtered to Q3 2013. What's happening is that you've drilled down to 2013, and the other visualizations ignore that. So when you select Q3, you get all Q3s regardless of year.

There's a request to change this that has woefully few votes given how unintuitive it is today: https://ideas.powerbi.com/forums/265200-power-bi/suggestions/6709520-drill-down-should-drill-or-cros...

Please add 3 votes if you haven't already and encourage others to do the same. 

@SqlJason has a more detailed blog post too: http://sqljason.com/2015/09/my-thoughts-on-cross-filtering-in-power.html

And there's a connect item here that predates Power BI as it is today: https://connect.microsoft.com/SQLServer/feedback/details/785853/power-view-cross-filtering