Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to 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.
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.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |