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)
RE: Ability to select multiple items in a report for cross-highlighting
I agree entirely with this. This needs to be a high priority development for Microsoft, as it is currently one of the few key areas where PowerBI is lagging behind other tools.
But overall, the work so far on PowerBI is fantastic.
RE: Ability to select multiple items in a report for cross-highlighting
Good blog post explaining this issue and suggested behavior: http://sqljason.com/2015/09/my-thoughts-on-cross-filtering-in-power.html
RE: Ability to select multiple items in a report for cross-highlighting
There's another submission already marked for review covering this: https://ideas.powerbi.com/forums/265200-power-bi/suggestions/6919488-ability-to-select-multiple-items-in-a-report-in-a Let's concentrate our votes in just the one.
RE: Ability to select multiple items in a report for cross-highlighting
As far as I love working with Power BI this is a major limitation indeed.
RE: Ability to select multiple items in a report for cross-highlighting
There is a page level filter and a visual level filter, but I would like a way to select multiple visualizations for a filter and link it to one filter without having to change multiple filters each time. It would basically be linked like the page filter but not to every visualization on the page. For example, say I have 3 graphs and I would like one graph to always show the whole range while the other 2 change based on the criteria I set on the single filter that is linked to those 2 visualizations. Excel does this with its slicers by setting relationships to individual pivot tables.
Also, I am surprised that you don’t have a nice slicer view like in excel 2013. In desktop I have to select and de-select and it looks out of date.
RE: Ability to select multiple items in a report for cross-highlighting
The new feature "Visual Interactions" is great. However, it would be even greater to be able to do multiple cross-filters in multiple charts to further narrow down the filtering. Today a new click in another chart resets the current cross-filter. When analyzing data this type of functionality would help a lot - currently you need to manually set a filter that corresponds to the cross-filter you just made to further narrow down the analysis.
RE: Ability to select multiple items in a report for cross-highlighting
I agree that this is a major limitation for Power BI. The selection of multiple items should not be limited to one graph but multiple the same way as with QlikView
RE: Ability to select multiple items in a report for cross-highlighting
Ability to highlight data from more than one visualization instead of just multiple items from on visual.
RE: Ability to select multiple items in a report for cross-highlighting
This is a major limitation for Powerbi. I love the product so far, but you should be able to select multiple items to drive a line chart.
RE: Ability to select multiple items in a report for cross-highlighting
When visualising data in PowerBI, users can hold CTRL and click on multiple series in a chart to visualise data only across those series.
My users are complaining that it is not possible to do so across different charts.
For example, in chart A for region I might like to select the series OHIO and FLORIDA. In chart B (fruits) I would like to select only APPLES and BANANAS.
I am aware that filter could do the trick but this required filters being added to the canvas in advance.