Forum Discussion
Dual Y axis in Line chart
Well done Power BI. You're supposed to act as a SQL Server front-end, yet, Excel has more functionality for visualisation. Why do you even exist?
Actually Option is there and I managed to find it after bit of playing ... yes it's not obvious.
Improtnant thing is you will not see the option as you have to scroll down to see it; after expanding the arrow Under Y-Axis (Column). Hope this helps.
Instruction here : https://powerbi.microsoft.com/en-us/documentation/powerbi-service-tutorial-combo-chart-merge-visualizations/#see-also
That's not what people are trying to solve for. We need to be able to plot 1 measure on the primary axis and another on the secondary.
Old thread but I've been looking for something similar for a while. Turns out Zoomcharts Advanced Drilldown Column Chart already does this and probably has for a while... I'm disappointed I didn't realize it sooner because I bought it a while ago for grouped stacked columns, another not-available-out-of-the-box feature that I needed.
Don't be fooled by the name, you can draw up to 12 series and they can all be lines (not columns). Primary and Secondary Y Axes available.
Hope this helps someone else.
