Dual axis chart - lines only?

[Anonymous]

Hello - I frequently come across scenarios where I want to show line graphs but they have different magnitudes. I know how to make a dual axis chart with a line + column combo, but I can't find the option to make a line-only version work. (Excel can easily do this however.)

An example I'm dealing with is where I'd have an absolute measure (such as $ amount of annual GDP) on the left y axis and the YoY % measure on the right y axis.

Again, this has to be lines for both. Thanks in advance for the help!

-Matt

[SteveCampbell · Accepted solution]

You can use the charticulator,

https://charts.powerbi.tips

Here's a tutorial on how to make what you want. There's also included a github link with the finished visual if you want.

Thanks!

Appreciate your Kudos
Connect with me!

Stay up to date on  
Read my blogs on  

[Anonymous]

Hi @SteveCampbell , 

This charticulator is only for csv files, but if somebody is making dashboards using oracle database live data, then it is not possible to use charticulator.

Am i right ?

Is there any provision for the same ?

Thanks !

[SteveCampbell]

The tool can use any data source. You will use csv field to design it if you make it in the site.
It will export a custom visual that you can use in power bi with any data, just like any other visual.

There’s a custom visual available to download already built on that link, so you can try it without having to make one yourself.

[Anonymous]

Hi,

Did you try Multiple axis chart in Power BI?

[Anonymous]

@Anonymous Show me where that is please? Not sure what you are referring to

[Anonymous]

https://docs.microsoft.com/en-us/power-bi/power-bi-custom-visuals

[Anonymous]

Search Marketplace Visuals for Multiple Axis Chart - XViz and give it a try. You can search and add marketplace visuals from Power BI desktop.

[Anonymous]

@Anonymous Thank you for the recommendation, but that is a third party plug-in that leaves a lot to be desired. (Not to mention that it tries to nudge you into paying for it.) Is there not a standard microsoft-built option for this? It seems like a rather big issue that PBI cannot easily replicate excel features.