Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Score big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount

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

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
Status: Needs Votes
Comments
stuross1129
Frequent Visitor
Anytime exclude is available to use, regardless of type of visualization, there should be option to exclude from current visual, current page, or entire pbix.
Casper_Rademake
New Member
I agree with this idea and voted for it. I think it should be selectable by user, whether the exclude filter should apply to visual level, report level or page level. Users already have the possibility to apply usual filters to either visual level, report level or page level, so they should be familiar with the concept (or if not, can be educated to be)
andy8
New Member
I would like to see the ability to move exclusions from one page to another. Right now I have a chart with 200 exclusions and I would like to get those same exclusions copied to other pages. Right now I have to do it manually which takes a long time!
tim_mortlock
New Member

If only they'd do this. It would be so handy.

keith_johnson
New Member

Exactly! Very confusing to users that they can exclude a data point but that exclusion doesn't effect other, related visuals! Excluding a data item/group from just the one visual is absolutely worthless to me!

fbcideas_migusr
New Member
Status changed to: Needs Votes