Sometimes you may need to use R or Python visuals to visualize your data the exact way you want. A while back, I wrote a blog post for Matt Allington’s blog over at Excelerator BI on how to create a basic “dual-axis line chart” as well as a fully-functioning 3D scatter chart! The dual-axis line chart in Power BI has been requested for years, but Microsoft has not provided a built-in solution as of yet.
For now, take a look at the above video on how to create the dual-axis line chart in Power BI or hop on over to the blog post on Matt’s site to read the article. I’m also including my 3D scatter chart video below for those who are interested. I personally love the ability to rotate a scatter chart within Power BI!