cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Advocate I
Advocate I

Dual Y axis in Line chart

Hi,

 

I'm working on a line chart and displaying 2 columns Project count and test count. Project count is in tens of number and test count in thousands.With a single Y axis ,the Project line almost looks flat.

 

Is there any option to have a second Y axis. I see that this option is there in Line and stacked column chart. 

But we want to have the columns projection as 2 lines and looking for it in Line chart. Please help.

 

Thanks.

17 REPLIES 17
Highlighted
Advocate I
Advocate I

I also throw my dis-affection regarding the lack of visual support for complex (or not so complex) data.  PowerBI needs to at the LEAST parallel Excel for graphs and visuals.  The expecation would be that PowerBI would exceed the Excel capabilties "out of the box"

Highlighted
Helper III
Helper III

I can't agree more. Power BI is meant for finding trends in data etc, how are you meant to find a trend if you can't compare 2 different types of data??

 

I spoke to Power BI and they said I could go to one of their partners and pay them to make a custom visualisation for me. If I am paying this much for Power BI, shouldn't I expect it would do something simple as this (look at how google charts does it, its simple as and you can add more than 2).

 

The way to implement this (especially more than 2) would be to have the name and values in the y axis for which ever line you hover over.

Highlighted

Not sure when it was added but the Line and Clustered Column Chart visual has the ability to define 2 Y axes. 

Seems to work as expected when I show all my data unfiltered.

When I apply certain filter values, the left Y axis disappears... Apparently, there are some values that don't compute somehow for the axis.  I did some troubleshooting and determined that the left y axis in my case is for the lines and 2 of the line series values rely on DAX Percentile function. I tried to capture any error condition on the dax formula so it now looks like:

P90Value = IFERROR(PERCENTILE.INC(tx_vEvents[eKpiNotifyAge],.9) , 0 )

But the Y axis still disappears under certain (but not all) filters.

Please advise Microsoft - thanks!
Highlighted

I know this is old but anyone still looking, but this blog explains how to create dual y-axis chart, and has a link to the finished visual:

 

https://powerbi.tips/2019/09/dual-y-axis-line-chart/

 

Annotation 2019-10-23 151620.png

 

 

 

Appreciate your Kudos
Connect with me!

Stay up to date on  linkedin-logo.png
Read my blogs on  powerbi.tips_.png



Did I answer your question? Mark my post as a solution! Proud to be a Super User!


Connect with me!
Stay up to date on  
Read my blogs on  



Highlighted

Really helpful.. 

 

Thanks to your efforts. 

Highlighted
Regular Visitor

Highlighted
Regular Visitor

I have an issue with the secondary Y-axis data labels.  I am trying to figure out a way to turn off the data labels on the secondary y axis line chart.  That option probably doesn't exist but having data labels on the secondary y axis makes my graph look super busy.

Highlighted

Guessing that you mean "having data labels on the series elements that relate to the secondary axis"?  the whole idea behind adding a secondary axis is to show the scale of those series elements that have a different scale from the primary.  You can of course selectively show labels on the various Series elements  (Line and clustered column chart--Data Labels--Customize Series).  Unlike Excel though, you can't format each data point.

 

Hope this helps!

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!

secondImage

Create an end-to-end data and analytics solution

Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.

Top Solution Authors
Top Kudoed Authors