Reply
Established Member
Posts: 186
Registered: ‎09-07-2017
Accepted Solution

2 Y axes

Hi all,

 

I had a question regarding the line chart visual I want to achieve something like this:

Afbeeldingsresultaat voor 2 y axis chart

Two Y-axes in the same line visual, so far I have'nt been able to achieve this. It would be great if someone knew of a way or knew about a custom visual for example.

 

Regards,

L.Meijdam

 

 


Accepted Solutions
Super User
Posts: 10,605
Registered: ‎07-11-2015

Re: 2 Y axes

I am not aware of any custom visual in the store for that. Probably need to look at an R visual.

 

See previous thread:

https://community.powerbi.com/t5/Custom-Visuals-Ideas/Dual-Y-axis-in-Line-chart/idi-p/153593

 

Combo charts can have 2 y-axis but one is a column and one is a line.

 

These are not exactly what you want but you may be able to get there:

https://stackoverflow.com/questions/26727741/how-to-show-a-legend-on-dual-y-axis-ggplot

https://stackoverflow.com/questions/26336827/how-to-align-a-bar-and-a-line-chart-in-ggvis-in-a-dual-...


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!


View solution in original post

Highlighted
Regular Visitor
Posts: 15
Registered: ‎11-08-2017

Re: 2 Y axes

[ Edited ]

Here is a link on how to create a Dual Y-Axis Line Chart using R Visuals in Power BI.

 

https://www.youtube.com/watch?v=sepAWgLOCBDual Axis.jpg

View solution in original post


All Replies
Super User
Posts: 10,605
Registered: ‎07-11-2015

Re: 2 Y axes

I am not aware of any custom visual in the store for that. Probably need to look at an R visual.

 

See previous thread:

https://community.powerbi.com/t5/Custom-Visuals-Ideas/Dual-Y-axis-in-Line-chart/idi-p/153593

 

Combo charts can have 2 y-axis but one is a column and one is a line.

 

These are not exactly what you want but you may be able to get there:

https://stackoverflow.com/questions/26727741/how-to-show-a-legend-on-dual-y-axis-ggplot

https://stackoverflow.com/questions/26336827/how-to-align-a-bar-and-a-line-chart-in-ggvis-in-a-dual-...


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!


Established Member
Posts: 186
Registered: ‎09-07-2017

Re: 2 Y axes

Hi @Greg_Deckler,

 

It's a shame since it can be pretty convenient, anyway thanks for the links. I voted for the idea in the hope to raise some awareness for it. I will deffinitely look into the other links, thanks for sharing them !

 

Best regards,

L.Meijdam

Regular Visitor
Posts: 37
Registered: ‎07-17-2018

Re: 2 Y axes

Did you find a solution for this ? If yes ,could you share with us ?

Established Member
Posts: 186
Registered: ‎09-07-2017

Re: 2 Y axes

Hi @d_u_a,

 

I changed my approach on the subject so in the end I did not find/use a solution.

 

Best regards,

L.Meijdam

Highlighted
Regular Visitor
Posts: 15
Registered: ‎11-08-2017

Re: 2 Y axes

[ Edited ]

Here is a link on how to create a Dual Y-Axis Line Chart using R Visuals in Power BI.

 

https://www.youtube.com/watch?v=sepAWgLOCBDual Axis.jpg