Forum Discussion

cyclist007's avatar
cyclist007
Responsive Resident
9 years ago

Exclude/Include to act as filters & Exclude/Include for Granular data

Hi,   I am struggling with how can I achieve two things with respect to Exclude/Include functionality (when you right click on column in a column chart you can exclude that column/data category). N...
Tips and Tricks
v-ljerr-msft's avatar
v-ljerr-msft
Microsoft Employee
9 years ago

Hi cyclist007,

Currently, the exclude option works as a visual level filter, and I don't think there is an option to extend this to be page/report level filter. So you can put it up as an idea on Power BI Ideas, and I believe it will be a great idea. :smileyhappy:

2. The include exclude feature does not work on scatter plots (where there is granular data). I dont understand why. It would be very useful to exclude certain data points (that are mostly outliers), and hence result in the scatter plot axis resizing (and trend lines rebuilt) for the remaining data points.

Based on my test, the include/exclude feature works on Scatter chart visual.

 

 

Regards

  • cyclist007's avatar
    cyclist007
    Responsive Resident
    9 years ago

    v-ljerr-msft Thank you for the response 

     

    I am sharing two images and you can see below the include/exclude options do not show up on the left hand side scatter plot that has granular data (that is, I cannot filter out individual tickets), while it does allow me to exclude a ticket category (in this case Severity 2) on the 2nd scatter plot (does not have granular data and was originally a column chart). Is there some other reason that I could be in play?