In this Power BI tutorial, learn how to perform crossover analysis in Power BI. With the default Stacked Area Chart, you will be able to create a beautiful crossover plot to highlight when metrics go above or below each other. Stock traders will often look at the crossover of metrics like moving averages to determine their trading strategy. It’s easy to perform crossover analysis in Power BI, though it takes a little outside-of-the-box thinking.
I hope you enjoyed learning this advanced trick! If you liked it, make sure to check out my Training courses here. All memberships grant you access to a live SQL Server database to practice Power BI!
Amazing technique, thank you!
I’m trying to reproduce Jira’s created vs. resolved cumulative chart.
When there is more created issues upper line is red, when there is more resolved issues it turns green.
I successfully reproduced the crossover, but my upper line is always green despite the trend. Not sure how to fix that.