Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
Anonymous
Not applicable

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

 

 

2 ACCEPTED SOLUTIONS
Greg_Deckler
Super User
Super User

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-...


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

View solution in original post

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

5 REPLIES 5
Greg_Deckler
Super User
Super User

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-...


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

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

Anonymous
Not applicable

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

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

Anonymous
Not applicable

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

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.