abhishek sreesaila on 04 Jan 2015 16:37:48
Ability to select multiple items in a chart say multiple bars, pie's etc and automatically have filters applied to all the existing reports. this helps to highlight anomalies and see all the surrounding reports changes as we do it and showcase risks/opportunities
Administrator on 09 Feb 2018 05:00:49
As of the February update, we now support cross-highlighting across multiple visuals! You can read the details in my blog post: https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-february-2018-feature-summary/#crosshighlight
- Comments (150)
RE: Ability to select multiple items in a report for cross-highlighting
this is need it for detail analysis
RE: Ability to select multiple items in a report for cross-highlighting
This is partially implemented (multi selection within one chart). What is missing - selecting multiple items from different charts
RE: Ability to select multiple items in a report for cross-highlighting
Missing this feature for ages! Why does it take so much time to add it, all the functionality is already developed :(
Dear Power BI development team, please, don't "deselect" whatever is selected in a visual when I click another visual (if [Shift] key is pressed or some screen key for touch users)
RE: Ability to select multiple items in a report for cross-highlighting
This is a basic foundation of every (?) other visual BI tool (Qlik, Tableau, Lumira etc.) It has been requested on so many places now but with very little response from the PBI team. The filter visual does exactly this, why cannot the charts and tables work the same way?
RE: Ability to select multiple items in a report for cross-highlighting
Just found a "slicer" visualisation tool in PowerBI desktop (not checked online version to see if it's there too). It does what it says on the tin! I have used multiple slicer tools on the same page, linked to different data fields and they produce multiple, stacked slices of the data.
Using the tool when a field linked to the tool is already in another visual is a little wasteful of page real estate, but it's a small price to pay for this functionality.
Well done DevOps team for listening to your customers and thank you!
RE: Ability to select multiple items in a report for cross-highlighting
All our users ask for this feature
RE: Ability to select multiple items in a report for cross-highlighting
I concur.
I believe that it is possible to slice a report using up to three concurrent filters, but only using the "Visualisations" control in the desktop. The filters have "visual", "page" and "report" scope. It appears to me that this was the original intention, but that requests for "point and click" functionality caused the "visual" filter to be extended to accept a "point and click" event (fair enough) *and* extended to have "page" scope", which then causes logical hierarchy decision problems if this is extended to multiple clicks.
Reason why I believe this is true. I experimented and found this behaviour: Create a report with multiple visuals, visualising the same data. Make one of them multiple level. Make a selection in a single level visual. Check that the visual in the multiple level visual changes (your data views intersect). Now go down one level in the multi-level visual. Click in an element of the visual. That visual changes but the single level visual doesn't. Now go up one level. The view at this level has changed (assuming that this view would change with the selection just made at the previous level).
Implementation suggestion: Users need to make a functionality choice and know that they have done so and how to reverse out if it was a mistake or if they get "buried". So implement a high level filter functionality selection menu with filter scope selections: Single slice page only; Multi slice page only; multi slice all report; Reset filters. Breadcrumbs would be good to follow selection history. If the user could select any breadcrumb to get to that filter point then a "reset" option isn't needed in the menu.
RE: Ability to select multiple items in a report for cross-highlighting
Yes honestly need this feature badly....Do Something about it MICROSOFT..
RE: Ability to select multiple items in a report for cross-highlighting
I totally concur. This is essential when we need to carry out investigative analysis. We investigate accidents which occur on merchant ships for our principals. We have tons of data which can help us identify patterns. I don't want to use too many visual as we prefer data in tables. The thing about tables is that data is filtered as per the row we select but as soon as data from the other table is selected, we ten to loose our previous selections, which to say the least is very annoying. Is there a way to lock the filters
RE: Ability to select multiple items in a report for cross-highlighting
This is a MUST for business understanding!