Synchronizing the secondary y-axis with the primary axis

[ldacey]

I created a Bar+Line graph with the bar on the primary axis and the line on the secondary axis. 

I am displaying the actual metric on the primary y-axis and the forecasted metric on the secondary y-axis. How can I force the secondary axis to be synchronized with the primary?

My issue is that when I drill down into a dimension, the actual performance might show a value like 10, but then the forecasted line graph might be at 15 but it would display lower than the actual value. The cause of this is that the secondary y-axis is scaled differently so it throws out any intuition of actual vs forecast that you would get from glancing at the chart.

[Anonymous]

Nothing better than changing the bar colour to the same as background colour is coming to my mind now.

[Anonymous]

Sorry to revive a dead thread but I have the same problem.  Does anyone know if this functionality has been implemented since this thread was posted or is it still impossible?  This seems like a pretty common thing people would want to do.

[Baskar]

go to format option , under  Y-Axis  u could find "Show secondary axis"  option . turn off that one it will help u 

[ldacey]

Hi, thanks but I want to have a secondary axis.

My primary axis already has three components of the metric (stacked bar chart) and then the secondary axis is a line graph showing the forecasted metric. The delta between the actual performance and forecasted performance should be apparent at a glance, but it isn't when the y-scales are different.

[farnazkz]

Set the minimum 0 and maximum range by fx (formula), count, sum or .. for both Y and secondary-Y axis to be the same.  

[Baskar]

This is u want it ? am i right dude .

let me if not .

[ldacey]

Negative. I need the y-axis to be exactly synchronized.

Primary y-axis = stacked bar chart showing the components of a metric (the three components sum up into a total), measured in minutes

Secondary y-axis = line graph showing the estimated/forecasted/predicted total for the same metric, measured in minutes

So if the primary y-axis goes from 0 - 25 minutes, I need the secondary axis to be in sync and also show 0 - 25. If I drill down into a specific dimension and the primary axis now goes from 0 - 5 minutes, I need the secondary y-axis to also go from 0 - 5.

[Anonymous]

Hi ,

Now its possible in line and clustered column chart,In formatting pane <-- Y-axis <-- put a range i.e start and end value in primary Y-axis(Optional) <-- switch off the secondary axis,its done primary and secondary Y-axis has been synchronised...

Drop a comment if it works in your case...

Cheers..

[Baskar]

cool dude i got it , got it .

for this my solution is obviously we cant do this. 

we can set static start and end point for both ,but that make no sense that i know .

sorry dude , i cant help u . even power BI also can't help i think so :-(((((((((((((((