Line chart with 3 axis?

[mueller_82]

Hello Power BI Experts,

I wonder if there is a possibility to visualize a line chart in power bi with 3 axis?

I saw there is an option for bar charts, but is it also possible for a line chart?

I wanna visualize months on x-axis, absolute values on y-Axis (on the left side of the line chart) and  additional deviation of absolute values in percents (axis right side of the line chart). 

Does power bi support such an option? Thanks for your answers!

Best Regard!

mueller_82

[Anonymous]

Hi @mueller_82，

There is only one Y axis on the basic line chart in Power BI Desktop, an idea about this issue has been submitted in this link, please vote it up. In your scenario, you would need to create R visual which is introduced in the following link if you want to have a second Y axis on the basic line chart.

http://robjhyndman.com/hyndsight/r-graph-with-two-y-axes/

Alternatively, you can create combo chart(Line and clustered column chart or Line and stacked column chart) which has secondary Y axis following the guide in this article: https://powerbi.microsoft.com/en-us/documentation/powerbi-service-tutorial-combo-chart-merge-visuali... .

Thanks,
Lydia Zhang