Forum Discussion
Visual filtering
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.
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-cross-filter-other-visu?tracking_code=a9f8e5d375b361d11c76a5a87f62d0bf
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
5 Replies
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.
yeah, more or less...
maybe is still unavailable
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.
