Skip to main content

Power BI

New

Add control to force shared Y axis for combined Column and Line chart

Vote (3) Share
Wyn Hopkins's profile image

Wyn Hopkins on 09 Aug 2020 02:31:23

It appears there's no easy way to have the line and column share the same Y axis in a combined Column and Line Chart.

Scenario: Actual = Column, Target = Line

I simply want both to be shown on the same scale

Depending on the mix of values, Power BI puts the line on a secondary axis that starts and ends at "Auto" which is completely out of scale with the "Auto" for the columns, or worse in that the axis is close and no-one realises it's not right.

Image here:
https://twitter.com/wynhopkins/status/1292287143251910656?s=20

Comments (1)
Wyn Hopkins's profile image Profile Picture

83199bb8 3cce-ea11-a812-000d3a579c34 on 09 Aug 2020 04:14:06

RE: Add control to force shared Y axis for combined Column and Line chart

This is actually a bug when I create the line / combo chart it says the Secondary axis is Off when it's clearly not. So toggling the Secondary Axis button on and then off again fixes this issue