How to dynamically remove an outlier

[Anonymous]

Hey all, please help me remove an outlier from my data. I have this table that contains country names and the amount of money spent in those countries, there is this one country that hugely out spent the other countries, when i put these data in a chart, it skews the data, is there a way i can make a slicer that dynamically remove this outlier when click on some button? thanks.

[v-eachen-msft · Accepted solution]

Hi @Anonymous ,

You can use filter pane to filter the data with rulers you want.

For example, here is the sample data. It looks bad.

Then I set a filter rule and apply it.

The visual is better now.

[Anonymous]

Thanks for your reply. I know how to do that, but i want to come up with a slicer that my client who isn't technical to use to be able to filter out the outliers him self, how can i do that though.