Dynamic Outlier Detection and Visualization with DAX in Power BI
ฝัง
- เผยแพร่เมื่อ 19 ส.ค. 2020
- Learn the theory and best methods to create a dynamic sensitive outlier detection and customize it to your particular dataset. Please find the data set and dashboard below:
github.com/Gaelim/Power-BI-DA...
Anomaly detection can be set up by using a number of statistical techniques to set the thresholds that signal were an outlier lives. These thresholds can be set with DAX functions such as PERCENTILE.INC or PERCENTILE.EXC. There are slight differences to how these out used. However, using these, you can mimic the quartiles that exist in a traditional outlier formula.
#Outliers
#Quartiles
#DAX
#AnomalyDection
#Power BI
Contact me on Linkedin:
/ gaelimholland
![How To Detect And Visualize Outliers Using DAX In Power BI [2023 Update]](http://i.ytimg.com/vi/kc3ztxkj0Tc/mqdefault.jpg)
Excellent video. Thanks!
Thanks! I correctly calculated the limits, however, when I needed to identify the rows I had some trouble. But after I saw your video, I completely understand. Thanks again!
Great Job! I am glad itt helped you out.
Excellent...resolved my problem
Thank you so much
Good explanation, esp using the Box & Whisker Plot. May I know how you can replicate the same analysis if there are multiple sets of data inside the table. For eg: In this case you have done for the count of users on a particular site, how to find outlier if there are 10 sites and each sites has its own set of users?
If the ten sites are in a single table, you can use a column that has a indicator of each site. ie, site 1, site 2, site 3. Then you would filter by that site and the DAX formulas for outliers should adjust to that sites data giving you the specification mean, median, outliers for that site.
@@absentdata Grt, thanks for that info
Could this logic be used to identify outliers within a given month, for example add a Month Index Column the far left, could we visualize that Feb has xx outliers within the Feb time frame and March has xx outliers within the March time frame?
Yes, that would work in this case since the outlier detection is based on the filtered data so you can filtered by month.
@@absentdata I had a similar issue. I am confident that using ALLSELECTED(outlierdata) instead on ALL(outlierdata) would make use of the slicers for months for example.
Thanks a lot for the video!
Could you please upload the worksheet to somewhere So we could refer the other parameters in the Dashboard too
Sure you can check out the descriptions. Make sure you subscribe :)
for me, it's not working, unfortunately. I get 'outlier' in the 'Outlier formula' calculation for every value. Do you know why?
my table has two columns.. date and name and then revenue amount. is it still possible? i am trying to follow your video.. but unfortunately it is not possible with two columns in the table. i there a way? thank you for your great hard work..
Yes its is possible the calculations work on individual columns so you shouldn't have an issue. I believe in your case you are using Revenue for your outlier column
I am having the same problem. I have a table with date, name and sales amount. So the formula is giving me an error. Did anyone find a solution?
I did the q3,q1,iqr, max and min formulas correctly but the outlier formula shows me the following message ""A unique value cannot be determined for the 'demanda' column in the 'demanda' table." Thank you for helping me
you can post your DAX here and I can evaluate it.