Forum Discussion
Visual filtering
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
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.
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