Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Find outliners?

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 🙂 

Need Help
Show and Tell
  • v-yingjl's avatar
    v-yingjl
    6 years ago

    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.

4 Replies