Skip to main content
Microsoft Idea

Power BI

Completed

Ability to select multiple items in a report for cross-highlighting

Vote (1588) Share
abhishek sreesaila's profile image

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)
abhishek sreesaila's profile image Profile Picture

Michael Shparber on 05 Jul 2020 22:49:56

RE: Ability to select multiple items in a report for cross-highlighting

It's a MUST!

abhishek sreesaila's profile image Profile Picture

Jake on 05 Jul 2020 22:49:35

RE: Ability to select multiple items in a report for cross-highlighting

This would be awesome!

abhishek sreesaila's profile image Profile Picture

Power BI User on 05 Jul 2020 22:49:32

RE: Ability to select multiple items in a report for cross-highlighting

This is a fundamental feature to get end users the story of the data they are looking at.
The end users expect the cross filtering to work across multiple tables.

abhishek sreesaila's profile image Profile Picture

Konstantinos Glykas on 05 Jul 2020 22:49:11

RE: Ability to select multiple items in a report for cross-highlighting

It should be possible to use visuals more like slicers and have the option to maintain their filter in addition to a new one when another visual is selected if, say, CRTL is held down (essentially do the same thing you can do in a single visual and select multiple categories but do it across multiple visuals and the categories withing them).
Although this is not exactly what I am looking for but may be relevant, the Sankey custom visual appears to maintain its highlighted segment by default even if another visual filter is applied.

abhishek sreesaila's profile image Profile Picture

John Fitzpatrick on 05 Jul 2020 22:49:00

RE: Ability to select multiple items in a report for cross-highlighting

Same idea has been posted multiple times. Please upvote on this one as it has the most votes and has gained MS attention.

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/6919488-ability-to-select-multiple-items-in-a-report-in-a#comments

abhishek sreesaila's profile image Profile Picture

Rafael Baleche on 05 Jul 2020 22:48:57

RE: Ability to select multiple items in a report for cross-highlighting

I build a report that uses several visuals as filters, but when I select a value from a visual, automatically the other selections in other visuals are cleared and it is not possible to complete the analysis, being necessary to include slicers on the canvas, reducing the space available for other visuals.

abhishek sreesaila's profile image Profile Picture

Michael Shparber on 05 Jul 2020 22:48:56

RE: Ability to select multiple items in a report for cross-highlighting

What is really missing in Interactions is one simple feature:
The ability to click on SEVERAL visuals to slice the report. Currently the users only can click one. The click on another visual "removes" previous selection, so the users loose their "data exploration thought flow"...
For instance, I have two bar charts (Product and Country) and one table. I would like to click on "Bicycles", then click on "USA" so the table shows only sales of Bicycles in USA.
Currently, when I click "USA", my previous "Bicycles" selection is removed.
Please add this option to keep all the selections from different visuals.
Thank you

abhishek sreesaila's profile image Profile Picture

Line on 05 Jul 2020 22:48:56

RE: Ability to select multiple items in a report for cross-highlighting

Yes, this really needed. And this I something that makes it difficult moving from QlikView/QlikSense as the users are used to this feature. Once you have it, you can live without it.

abhishek sreesaila's profile image Profile Picture

Evandro Muchinski on 05 Jul 2020 22:48:49

RE: Ability to select multiple items in a report for cross-highlighting

SUGGESTION: If the user holds CTRL and click in another visual, Power BI should keep the existing cross filtering.

abhishek sreesaila's profile image Profile Picture

Jack Wells on 05 Jul 2020 22:48:49

RE: Ability to select multiple items in a report for cross-highlighting

This would be incredibly helpful