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

7abb54a3 2f5b-4a24-a36e-5859b5fbb391 on 05 Jul 2020 22:25:00

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

I'm very surprised this is not possible. I was just doing a report of a annual budget where I want the users to be able to drill down from top level. First looking at teams, then functions, then allocated spending per partner. Now they get lost at second step when the first filter (teams) is lost. Sequential filtering...

abhishek sreesaila's profile image Profile Picture

dd11ac42 c871-4f43-b2c4-c997ebc70490 on 05 Jul 2020 22:24:57

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

This is certainly needed.

abhishek sreesaila's profile image Profile Picture

645edc46 ffb6-49b1-b7ff-7ad45d337135 on 05 Jul 2020 22:24:56

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

This would be extremely useful, as tableau is able to do this and everyone is expecting BI to do it as well. It would definitely help to further narrow down useful info in data sets.

abhishek sreesaila's profile image Profile Picture

6f6390db 22e2-4721-8c88-a946a3835372 on 05 Jul 2020 22:23:59

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

In my opinion, it is effectively a mandatory figure to do Data Visualization.

abhishek sreesaila's profile image Profile Picture

4a9fa078 a9bb-41a5-83a6-efb7f6900373 on 05 Jul 2020 22:22:35

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

Major limitation, I agree. I'm sure you guys can/will fix it.

Example use case: a simple sales report filterable by team name (shows in a bar graph) and also by product category (shown in a donut chart). Not being able to filter by both, when you can filter by either independently, is a confusing user experience and a missed opportunity for insight into the cross-section of the two dimensions.

abhishek sreesaila's profile image Profile Picture

0df430bc 18fa-4712-9110-647e3a5b44be on 05 Jul 2020 22:22:20

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

.or it would be nice to have a possibility to 'overrule' a report/page filter, within a visual (filter).

Now it merges both filters, so filtering “White” on visual level and “Black” on page level results in “nothing”. As far as I know you can’t influence this behavior. (I know a DAX measure could do this trick, but I am not comfortable having ‘complex logic’ or multiple measures)

For instance: you could set ‘last half year’ on the page (to filter most of the visuals and ‘time slicer’ on the page), but you could also add a visual on the same page that shows ‘last 2 years’.

abhishek sreesaila's profile image Profile Picture

b6a0ffb3 0d27-e711-80f4-c4346bac219c on 05 Jul 2020 22:17:53

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

I understand this to be that multiple charts can act as filters within the report/dashboard. This is different than allowing the selection of multiple items within a single chart. I believe this is quite important. For instance, a trended chart + a pie chart for customer groupings can both filter a third object.

abhishek sreesaila's profile image Profile Picture

bbed4887 2c99-ea11-a811-000d3a579c39 on 05 Jul 2020 22:17:11

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

Very important asset!! (Like the functionality of Qlik...)
That would be necessary for serious Analysis of causes. The easiest way to implement this could be, to make it able to define Slicers as "global". They should then appear in every page of the Report and stay connected. So users can set a slicer in one page and have it set in the next page.

abhishek sreesaila's profile image Profile Picture

b7f6a85d b076-4ead-91e0-490b514904eb on 05 Jul 2020 22:15:32

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

I suggest to give a possibility to use ctrl+shift to copy/paste and move all selected objects parallel vertically or horizontaly

abhishek sreesaila's profile image Profile Picture

1df914d3 6a2f-4022-9ae6-d439cbb600be on 05 Jul 2020 22:15:16

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

I agree with everyone here, the ability of selecting multiple items should be priority.