Forum Discussion
Force second y axis
Is there a way for force a second y-axis? I create graphs with combo lines and bars. Bars on the primary y-axis and are typically hudreds of thousands of dollars, while I would like to have my lines on a secondary y-axis to reflect dollars into the millions. Sometimes Power BI decides to aoutomatically create the sencondary y-axis, but I would like to force this everytime. It looks strange with my primary y axis values (bars) are so small and low compared to my secondary (line) values. This can be done easily in Excel, why not here?
14 Replies
I know of no way to force a default behavior for newly created charts, but you can always turn on the secondary axis for any combo chart (section about halfway down the page - sorry, no anchor links) in the visual formatting menu.
I don't see the "Show Secondary" in the Y axis options for a combo chart. Has this option disappeared?
Yes, I have the same issue. Can someone please answer how to get the option to show up for controling a second Y axis. I see this, https://powerbi.microsoft.com/en-us/documentation/powerbi-service-tutorial-combo-chart-merge-visualizations/#optionally-turn-off-the-second-axis But this is just not showing up for us. The chart looks rediculous without being able to turn the second Y axis on.
Awesome! Sorry I thought I did my due diligence looking for that scroll bar as well. :smileyembarrassed:
Thanks for this. I have also just spent ages looking and I too missed the grey scrollbar inside the second grey scrollbar inside the sligtly darker grey background. It is a bit too subtle!
I was just trying to fix the fact that on a grouped bar and line graph it had set the scales differently for the line and bar values. I would have though it better to default to the same scale for both (i.e. 0% - 100%) as I would have thougt that would normally be the desired outcome.
