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.
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 🙂
Solved! Go to 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.
@Anonymous , refer if this can help
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/
You can use Scatter chart and in Play axis you can put "Date" in it.
Proud to be a Super User!
Hi @FarhanAhmed
Thank you, but I wondering where shall I put all my products?
Details? Legend? X Axis? Y? since there is so many???
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.
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 |
---|---|
114 | |
99 | |
82 | |
70 | |
60 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |