Forum Discussion
Secondary axis problem with "Line and stacked column chart"
I've got a line and stacked column chart that shows weekly values as columns and a measure of the average for the last 6 months as the line. When all data is showed it workes well, but if I use the slicer, a secondary axis is added for the line which messes up the display. Is there any way to stop the use of the new y-axis?
All data shown:
All data
Using slicer:
Single account selectedNote the new secondary y-axis. The measure gives the correct number, but the two y-axises (sp?) as now not syncronized.
TIA!
Dennis
8 Replies
Did you ever find a solution to this problem?
I'm have the same issue, if the two data sets are not close it creates a secondary Y-axis.
I had the same issue as you both for Line and stacked column chart.
For me, the 2nd y-axis doesn't appear in PBI Desktop, but it does unexpectedly appear in powerbi.com app / workspace.
Hopefully Microsoft will fix this, but here's a workaround for the visual.
To prevent 2nd y-axis showing:-
- Show secondary on
- Align zeros on
- Show secondary off
SeanCommunity Champion
If after it appears you then go and turn off the secondary axis - does it still show up later?
ShelleyPost Prodigy
You can turn off the secondary axis: https://community.powerbi.com/t5/Desktop/Line-and-stacked-column-chart-Y-axis/m-p/48839#M19391
