Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

How to dynamically remove an outlier

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.

  • 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.

     

2 Replies

  • v-eachen-msft's avatar
    v-eachen-msft
    Community Support

    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's avatar
      Anonymous
      Not applicable

      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.