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

739fc267 3a91-4eca-a1f7-888729df15fa on 05 Jul 2020 22:42:07

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

Do you know if the multiple visualization filter was added to PowerBI? I'm trying to find exactly the same

abhishek sreesaila's profile image Profile Picture

dadae3be 923a-492e-8400-0ada8b9cf820 on 05 Jul 2020 22:40:27

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

Without this feature, several businesses I have talked to doesn't see the use case to switch to Power BI. They get the slicer concept but Power BI will be really only powerful when it has the multiple selection of visuals for [cross] filtering.

abhishek sreesaila's profile image Profile Picture

85547b2d aabd-46f7-b206-0042254cdb75 on 05 Jul 2020 22:40:27

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

Guys, this is not an Idea but a BUG; Similar feature perfectly works in MS Windows! I think this might have significant impact on decision whether to make Power BI standard tool for reports and analytics or not as most of our executives work on Macs!

abhishek sreesaila's profile image Profile Picture

d26c46f3 8807-44d3-882a-4b42740ce3f1 on 05 Jul 2020 22:39:50

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

I am really missing this feature. I am endorsing Chris Hutchins comment "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

a1aa1e00 f7ce-4361-ba80-11f258d8a166 on 05 Jul 2020 22:39:44

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

This is so desperately needed.
It would make Power BI so much better.

abhishek sreesaila's profile image Profile Picture

4ed89b9b fe15-460e-a1ee-432f69488a72 on 05 Jul 2020 22:38:37

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

I am glad this is under review. Ability to filter by multiple charts will make Power BI the BEST BI toll for business. e.g. by product by region.
Using slicers is waste of space not really a good user experience and so is using report or page level filters.

abhishek sreesaila's profile image Profile Picture

131ffe3a d399-4451-81dc-70f1e8a84b9d on 05 Jul 2020 22:35:08

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

Totally needed!
Currently, I have to add slicers in addition to charts in order to allow filtering on multiple dimensions.
Slicers are unnecessary if you already have charts that show data you want to filter by. They take space.
I should be able to select multiple values on multiple charts so that selecting a value on a chart WILL NOT CANCEL the selections on other charts.
Thank you!

abhishek sreesaila's profile image Profile Picture

4f0999e8 41bd-4901-8ff6-94005adb2ebb on 05 Jul 2020 22:35:06

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

I really missed this feature on some projects.

abhishek sreesaila's profile image Profile Picture

a8c9bc29 bae1-426e-890c-dd7c5accc249 on 05 Jul 2020 22:34:19

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

We are new into PBI and it would seem to be a basic requirement for users doing some kind of analysis with a report that they can select 2 different charts to filter the data on. I appreciate the same thing can be achieved by using page or report filters but it's not quite as good as using the charts. 1 example is we have a long category in a graph that is sorted by value so we see the top 10 items. The category could be in a page or report filter but the sorting is different and users have to scroll and search for the items to filter.

abhishek sreesaila's profile image Profile Picture

ccb0ce8b 87a1-4e82-97b6-48394c8034da on 05 Jul 2020 22:33:30

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

Ability to adjust the unit of a visual when drilling down. Example i have product sales in millions and when i drill down to analyze Product Category or Segment i no longer want the unit to be millions but instead thousands. It would be good to add a field to adjust the unit to each level of the hierarchy.