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!
Parker Stevens
Parker is the creator of the BI Elite YouTube channel, a community of over 30,000 students learning Power BI, DAX, and Power Query. He is a Microsoft Data Platform MVP for his work with Power BI and continues to provide elite Power Platform training courses to help data analysts, BI developers, and citizen dashboard creators reach their goals. Parker is committed to producing high-quality training content that is also extremely cost-effective, to ensure that the largest amount of users can benefit from the content. Training courses located at https://training.bielite.com/
1 Comment
Leave a ReplyCancel reply
This site uses Akismet to reduce spam. Learn how your comment data is processed.
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.