Skip to main content
Microsoft Idea

Power BI

Needs Votes

Excluding data on a Visual/Scatter plot should extend as a page/report level filter

Vote (90) Share
Mustafa Biviji's profile image

Mustafa Biviji on 23 Jun 2017 00:26:18

When data is plotted on a scatter plot, we get to see distribution by two metrics defined on X & Y-axis. This also helps in identifying outliers. On right-clicking we generally get to exclude certain data points from the visual and then see the visual without those data points (that is we filter out the data points at the visual level).

I would like to see an extension of this concept to filter out those data points across all visuals on that page/report that are interact with the original visual (where data points were excluded).

Why this is helpful? Suppose you identify certain outliers on a scatter plot that you would like to filter out from all your analysis for understanding the data better. You right click on those data points and exclude them which results in a visual level filter, but those data points (outliers) still exist in other visuals and hence misleading the end-user. If they were excluded from all related visuals that would truly help analyzing data without outliers across the report page.

More details with screenshots can also be seen here: http://community.powerbi.com/t5/Desktop/Exclude-Include-to-act-as-filters-amp-Exclude-Include-for/m-p/199681#M87852

Comments (15)
Mustafa Biviji's profile image Profile Picture

Ryan R on 05 Jul 2020 23:21:13

RE: Excluding data on a Visual/Scatter plot should extend as a page/report level filter

I agree. Excluding the data in question shows how it impacts all visuals on the page. This would really helps on the easy of data analysis.

Mustafa Biviji's profile image Profile Picture

Power BI Ideas Admin on 05 Jul 2020 23:19:15

RE: Excluding data on a Visual/Scatter plot should extend as a page/report level filter

This feature would be very useful not just from a scatter plot but in all visuals.

Mustafa Biviji's profile image Profile Picture

Jeff Leahy on 05 Jul 2020 23:18:01

RE: Excluding data on a Visual/Scatter plot should extend as a page/report level filter

I have a stacked bar chart that I use, and every month there seems to be a different outlier that is totally screwing up my data. I want to be able to right click and exclude, and the entire page would filter, excluding this data field.

Since every month the outlier is a new, I can't simply make a dynamic bookmark or group. PLEASE find a way to give the ability to exclude an entire page, based on an exclude from one visual.

With this feature, it would probably make sense to not "hide" the bar you are excluding, but rather highlight all other bars with the "excluded" item not highlighted.

Mustafa Biviji's profile image Profile Picture

Andre on 05 Jul 2020 23:16:07

RE: Excluding data on a Visual/Scatter plot should extend as a page/report level filter

I'm using scatterplot and have same the issue. The Feature will be very helpful.

Mustafa Biviji's profile image Profile Picture

Anders on 05 Jul 2020 23:14:33

RE: Excluding data on a Visual/Scatter plot should extend as a page/report level filter

This will be very useful to do, not only from a scatterplot but also from a simple table.