“Power BI has a major limitation!”
“I can’t do this business critical chart in Power BI that I can do in Excel”
Sometimes just because you can do something doesn’t mean you should and Power BI has a much better way of dealing with these kinds of charts.
Climatemps has a great chart and I know I’ve used it as an example of what not to do but that’s meant from a business and driving actions pespective. Have a look at their site and have a look at what they do.
http://www.sapporo.climatemps.com/