Find outliners?

[Anonymous]

Hi,

i have a data Set which have maybe approx 100 000 rows (because there is so many dates)

And I I have plotted a line chart, who shows 

axis: date 

legend: product 

values: price 

And since I have so many products I can't gave them in the same graph, so I made  an slicer for ech product to see how the prices have developed 

but my question is, if I want to have a separated graph which will show if there is a big jump/a freeze in the price a certain period.. how can I do that?

i was thinking of plotting all the product and on the y axcis and have date on the x asis., and the look for outliners.

any help is perfect 🙂 

[amitchandak]

@Anonymous , refer if this can help

https://towardsdatascience.com/this-article-is-about-identifying-outliers-through-funnel-plots-using-the-microsoft-power-bi-d7ad16ac9ccc

https://www.youtube.com/watch?v=RoglNZ2dXW8

https://www.mssqltips.com/sqlservertip/5547/anomaly-detection-without-any-coding-using-power-bi/

Or

https://sqldusty.com/2018/08/31/calculating-quartiles-with-dax-and-power-bi/

[FarhanAhmed]

You can use Scatter chart and in Play axis you can put "Date" in it.

[Anonymous]

Hi @FarhanAhmed  

Thank you, but I wondering where shall I put all my products? 

Details? Legend? X Axis? Y? since there is so many???

[v-yingjl · Accepted solution]

Hi @Anonymous ,

The scatter chart will be set like this:

You can also try to use waterfall chart to display the trend.

Best Regards,
Yingjie Li

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.