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

4133d0ca 65e2-4fa9-acb1-a84675ba8aa9 on 05 Jul 2020 22:33:09

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

Absolutely agree. This is the biggest shortfall I encountered when comparing PowerBI to Sisense.

As a work around, I have to provide slicers for the data behind each visual which not only makes for a cumbersome/cluttered report but also, when the slicers are used, results in the removal of bars from the bar chart, slices from the pie graph, etc. instead of "greying" them out as occurs when a visual is interactively filtered by clicking on a bar or slice in the visual itself. In other words, using slicers as a work-around throws away the context of overall data behind the visual.

abhishek sreesaila's profile image Profile Picture

93e3ca46 7c9d-4451-be6f-340dfc159eb5 on 05 Jul 2020 22:32:22

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

Needed. "Use chart as slicer" would resolve this. Requirement is for the selection in chart A to globally filter the rest of the report, and not be reset to all when a selection in chart B is made.

abhishek sreesaila's profile image Profile Picture

dd258275 aec4-4504-b5a3-79e6caf37997 on 05 Jul 2020 22:31:37

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

You could try out the following dax code:

CALCULATE(SUM([Sales]);ALL([Date]))

This would override any date filter. You can use the same for any other filter such as product category, subsidiary, etc.

abhishek sreesaila's profile image Profile Picture

8a96940e dcdb-48e2-97c6-f454a6d5a9aa on 05 Jul 2020 22:30:44

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

For this I added my votes here ? https://ideas.powerbi.com/forums/265200-power-bi/suggestions/6709520-drill-down-should-drill-or-cross-filter-other-visu

abhishek sreesaila's profile image Profile Picture

dc95a800 1364-4b90-8904-97b1e3a2b17f on 05 Jul 2020 22:30:23

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

We desperately need the ability to apply concurrent filters from multiple charts. Qlik does this, why can’t Power BI. This topic is also related to global filtering.

abhishek sreesaila's profile image Profile Picture

b1a92dec c272-447d-be93-5e4edf07a60e on 05 Jul 2020 22:28:49

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

There are other registered ideas that are almost the same as this one. This uncontrolled idea submitting option is not efficient. I think this is a really important feature but because of the inefficient registration does not get the votes it deserves (now its fragmented).

abhishek sreesaila's profile image Profile Picture

90948579 07c7-452d-be15-a3850ed41a77 on 05 Jul 2020 22:27:44

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

This is definitely an important feature to data visualization. It is the only reason why I haven't switched from Tableau to Power BI. Please add this feature in the near future.

abhishek sreesaila's profile image Profile Picture

dd11ac42 c871-4f43-b2c4-c997ebc70490 on 05 Jul 2020 22:26:47

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

We need this! Any news?

abhishek sreesaila's profile image Profile Picture

6f139c6b 8c80-4ee7-9bb6-a669fd5681c1 on 05 Jul 2020 22:26:25

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

I need this function, otherwise I will have to use Tableau ... it's a shame because the power has potential.

abhishek sreesaila's profile image Profile Picture

36013236 4e3a-4a4c-b96c-3942d2b7b0dd on 05 Jul 2020 22:26:03

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

I'm still surprised there's been no movement on this. This would allow a lot of quick analysis. Even if it's as simple as holding down ctrl when you select (although not sure how to deal with mobile/ ipad)