Skip to main content

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

ce84b7dd 7f25-4a1a-8164-2af3ffee8e68 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

52b5cce4 5162-45fc-a468-4609777326e8 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

136c5525 4904-49bb-8784-da679fa3c44d 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

44d72a87 f35f-4f9e-a704-dfdd7ffcb2f4 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

5d190a5b 4c28-4453-bf10-cf6372fdca5a 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

dd53a7e8 2a73-45ea-8a60-42d3fad5c9a0 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

f93db4e6 f311-45fb-8754-72b611fa2a9b 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

b2bf64b6 765f-42ce-a61d-e7450cab37c6 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

d67a6744 af8f-475f-9654-0f9178bf467a 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

2826746b 8215-4a3d-9ec2-66c1eaa6166e on 05 Jul 2020 22:48:49

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

This would be incredibly helpful